--
-- PostgreSQL database dump
--

-- Dumped from database version 9.1.2
-- Dumped by pg_dump version 9.1.2
-- Started on 2012-03-01 10:54:46 CET

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

SET search_path = test, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 199 (class 1259 OID 38309)
-- Dependencies: 1501 8
-- Name: poly; Type: TABLE; Schema: test; Owner: postgres; Tablespace: 
--

CREATE TABLE poly (
    gid integer NOT NULL,
    id integer,
    geom public.geometry(Polygon,3004)
);


ALTER TABLE test.poly OWNER TO postgres;

--
-- TOC entry 198 (class 1259 OID 38307)
-- Dependencies: 199 8
-- Name: poly_gid_seq; Type: SEQUENCE; Schema: test; Owner: postgres
--

CREATE SEQUENCE poly_gid_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE test.poly_gid_seq OWNER TO postgres;

--
-- TOC entry 3076 (class 0 OID 0)
-- Dependencies: 198
-- Name: poly_gid_seq; Type: SEQUENCE OWNED BY; Schema: test; Owner: postgres
--

ALTER SEQUENCE poly_gid_seq OWNED BY poly.gid;


--
-- TOC entry 3077 (class 0 OID 0)
-- Dependencies: 198
-- Name: poly_gid_seq; Type: SEQUENCE SET; Schema: test; Owner: postgres
--

SELECT pg_catalog.setval('poly_gid_seq', 3, true);


--
-- TOC entry 3070 (class 2604 OID 38312)
-- Dependencies: 199 198 199
-- Name: gid; Type: DEFAULT; Schema: test; Owner: postgres
--

ALTER TABLE poly ALTER COLUMN gid SET DEFAULT nextval('poly_gid_seq'::regclass);


--
-- TOC entry 3073 (class 0 OID 38309)
-- Dependencies: 199
-- Data for Name: poly; Type: TABLE DATA; Schema: test; Owner: postgres
--

COPY poly (gid, id, geom) FROM stdin;
2	2	0103000020BC0B0000010000000B000000370C10A558B4DABF1AB5FD0C612FE43F077BF1FCBBD6CDBF850E03442916ED3F1AAF75BA34D5CBBF0B88522C5A56ED3FF7167E3526D2C73F3BFFAE75BA34EB3FB95E3CFFAE75DC3FA0148B965570E53FFC26238EDA7EE33F7590CD1D5712D83F30911EA89CDDE13F3D537DE49B8CC0BF64F8D598480F843F52C451DBCF10C6BF5E836CEEB892B83FA00E03442916BD3F61537DE49B8CB0BF84F440E5EC16DE3F370C10A558B4DABF1AB5FD0C612FE43F
3	1	0103000020BC0B0000010000000A000000640FEAD1CAC0DABFA8D653CFF82FE43F807A7AC40C63C9BF0CABC1DC9906E43FB8E2E5B7779ECCBF751D41DFF25ADE3F6084AF11173FC23FF783D649EFFDD93F803B8CFD12DBABBFAE520CA6A8F4C43F785AF3A726AEC93FA0F9F2CB618885BF00B612B697557ABFB4386EE1F850B9BF00CEDC644808873FFF54F94ABD5AC6BF18995CCF8903C0BF3A9BD621CEC4C3BF640FEAD1CAC0DABFA8D653CFF82FE43F
\.


--
-- TOC entry 3072 (class 2606 OID 38314)
-- Dependencies: 199 199
-- Name: poly_pkey; Type: CONSTRAINT; Schema: test; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY poly
    ADD CONSTRAINT poly_pkey PRIMARY KEY (gid);


-- Completed on 2012-03-01 10:54:47 CET

--
-- PostgreSQL database dump complete
--

