· 10 years ago · Sep 22, 2016, 01:24 AM
1DROP SCHEMA IF EXISTS test;
2CREATE SCHEMA test;
3--
4-- PostgreSQL database dump
5--
6
7-- Dumped from database version 9.5.4
8-- Dumped by pg_dump version 9.5.4
9
10SET statement_timeout = 0;
11SET lock_timeout = 0;
12SET client_encoding = 'UTF8';
13SET standard_conforming_strings = on;
14SET check_function_bodies = false;
15SET client_min_messages = warning;
16SET row_security = off;
17
18SET search_path = test, pg_catalog;
19
20SET default_tablespace = '';
21
22SET default_with_oids = false;
23
24--
25-- Name: test1; Type: TABLE; Schema: test; Owner: -
26--
27
28CREATE TABLE test1 (
29 id integer NOT NULL,
30 geom public.geometry(Polygon,5514)
31);
32
33
34--
35-- Name: test1_id_seq; Type: SEQUENCE; Schema: test; Owner: -
36--
37
38CREATE SEQUENCE test1_id_seq
39 START WITH 1
40 INCREMENT BY 1
41 NO MINVALUE
42 NO MAXVALUE
43 CACHE 1;
44
45
46--
47-- Name: test1_id_seq; Type: SEQUENCE OWNED BY; Schema: test; Owner: -
48--
49
50ALTER SEQUENCE test1_id_seq OWNED BY test1.id;
51
52
53--
54-- Name: test2; Type: TABLE; Schema: test; Owner: -
55--
56
57CREATE TABLE test2 (
58 id integer NOT NULL,
59 geom public.geometry(Polygon,5514)
60);
61
62
63--
64-- Name: test2_id_seq; Type: SEQUENCE; Schema: test; Owner: -
65--
66
67CREATE SEQUENCE test2_id_seq
68 START WITH 1
69 INCREMENT BY 1
70 NO MINVALUE
71 NO MAXVALUE
72 CACHE 1;
73
74
75--
76-- Name: test2_id_seq; Type: SEQUENCE OWNED BY; Schema: test; Owner: -
77--
78
79ALTER SEQUENCE test2_id_seq OWNED BY test2.id;
80
81
82--
83-- Name: test3_ogc_fid_seq; Type: SEQUENCE; Schema: test; Owner: -
84--
85
86CREATE SEQUENCE test3_ogc_fid_seq
87 START WITH 1
88 INCREMENT BY 1
89 NO MINVALUE
90 NO MAXVALUE
91 CACHE 1;
92
93
94--
95-- Name: id; Type: DEFAULT; Schema: test; Owner: -
96--
97
98ALTER TABLE ONLY test1 ALTER COLUMN id SET DEFAULT nextval('test1_id_seq'::regclass);
99
100
101--
102-- Name: id; Type: DEFAULT; Schema: test; Owner: -
103--
104
105ALTER TABLE ONLY test2 ALTER COLUMN id SET DEFAULT nextval('test2_id_seq'::regclass);
106
107
108--
109-- Data for Name: test1; Type: TABLE DATA; Schema: test; Owner: -
110--
111
112COPY test1 (id, geom) FROM stdin;
1131 01030000208A1500000100000006000000951452B0C12822C12494668144B431C16EF852A2F82522C1CBF6596A48B331C1CA5FA6D8EA2322C16CBE8577D8B331C1CD302795682522C1804C85FE3CB531C13C774599C52722C19FAB702D0EB531C1951452B0C12822C12494668144B431C1
1142 01030000208A1500000100000008000000AD1493728E1F22C184CC3A74B4B331C1D0F33317D71D22C1B9D43790E6B431C157480718102022C14BFAF6388CB531C194A13A66372122C105357B5273B431C15F4FACA0862122C1C28A11D256B331C1822E4D45CF1F22C11A72AF92D1B231C159ADAA278B1E22C124DEF72AC3B231C1AD1493728E1F22C184CC3A74B4B331C1
1153 01030000208A1500000100000009000000547EC0F8192322C12014B10BCDB531C191D7F346412422C1D4B36D4940B631C1F00FC839B12322C1477A41C314B731C1054DFC790F2222C139D8D45E2AB731C1B51B38FB042122C14FCB77F509B731C1A779CB961A2122C1D2985BE343B631C1303342A7CE2122C147C4D26C93B531C1BD22DD837B2222C176E03C664BB531C1547EC0F8192322C12014B10BCDB531C1
1164 01030000208A15000001000000080000009243D1F3432722C1EEDC34AC18B631C1B78E4F458F2822C194DA8485A1B631C116C72338FF2722C1E8416DD0A4B731C121980FE06B2622C1E6265B6AA8B731C1E53EDC91442522C1F2ADB56896B731C1BA589664852522C1A061DF838FB631C16EF852A2F82522C1F312597811B631C19243D1F3432722C1EEDC34AC18B631C1
1175 01030000208A150000010000000800000095FFA3D82A1B22C1DB04A47B35B631C1D3BD7A36CD1A22C1F25CEA2190B431C1144698B3651722C1EE26C65597B431C161A6DB75F21622C1524B2D6B81B531C123E80418501722C1CF7D497D47B631C1CBB6D5AD561922C1C1DBDC185DB631C171B42587DF1922C14BFAF6388CB531C195FFA3D82A1B22C1DB04A47B35B631C1
118\.
119
120
121--
122-- Name: test1_id_seq; Type: SEQUENCE SET; Schema: test; Owner: -
123--
124
125SELECT pg_catalog.setval('test1_id_seq', 5, true);
126
127
128--
129-- Data for Name: test2; Type: TABLE DATA; Schema: test; Owner: -
130--
131
132COPY test2 (id, geom) FROM stdin;
1331 01030000208A1500000100000007000000BF8EBA307E2522C11FA8D35ECAB231C1C3C4DEFC762522C1C28A11D256B331C12B0458785D2622C19489B93E9BB331C136D54320CA2422C12494668144B431C11BF60D67702322C1031A69EC76B431C141A62FC8362322C1C9DB47044CB331C1BF8EBA307E2522C11FA8D35ECAB231C1
1342 01030000208A15000001000000080000009A433CDF322422C1428EAEA09AB531C18D06738AC32222C19FAB702D0EB531C118258DAAF22122C1B7B9252AEAB431C1775D619D622122C1578151377AB531C1303342A7CE2122C119C37AD9D7B531C141A62FC8362322C10906FC0EF1B531C179C93E4A652422C1148D560DDFB531C19A433CDF322422C1428EAEA09AB531C1
1353 01030000208A15000001000000070000004C70E1D21B1D22C1F577FC878CB431C1A506B44C901922C13CA21B7E20B431C19DFF0EC4191822C189025F40ADB331C13BF6B9142C1722C1B068EFF7F4B431C1345BF238B81822C117A86873DBB531C15F487203FF1C22C1360754A2ACB531C14C70E1D21B1D22C1F577FC878CB431C1
1364 01030000208A1500000100000006000000ACBD639D222A22C1524B2D6B81B531C1722E776EF12522C149DFE4D28FB531C1A24AE167A92522C17EE7E1EEC1B631C1951452B0C12822C18FA460B9A8B631C17235B10B792A22C19B2BBBB796B631C1ACBD639D222A22C1524B2D6B81B531C1
1375 01030000208A15000001000000070000004EDCBE7F1E2022C196EE5C4E16B231C1D7953590D22022C1E83A33331DB331C1FEAAFA00141F22C1AFB280A173B331C1B779A16DF81A22C1FD2DD6C9FCB231C1F808F987181C22C1ACE1FFE4F5B131C159ADAA278B1E22C1E24EA010A3B131C14EDCBE7F1E2022C196EE5C4E16B231C1
1386 01030000208A15000001000000060000008DFF38ED3B1E22C1CF7D497D47B631C1DA584212411922C1185ED7C95CB731C12EC02A5D441A22C181B862AB3FB831C1419FF52AAF1E22C16AAAADAE63B831C13198E5B6492022C1D033B8D3C8B731C18DFF38ED3B1E22C1CF7D497D47B631C1
1397 01030000208A150000010000000700000047483141322622C14829767C0EB431C1A0E53D582E2722C14829767C0EB431C17F6B40C3602722C1F9AD205485B431C1F27BA5E6B32622C1CA91B65ACDB431C194A87403BF2522C1C776A4F4D0B431C1ACB629009B2522C1205E42B54BB431C147483141322622C14829767C0EB431C1
140\.
141
142
143--
144-- Name: test2_id_seq; Type: SEQUENCE SET; Schema: test; Owner: -
145--
146
147SELECT pg_catalog.setval('test2_id_seq', 7, true);
148
149
150--
151-- Name: test3_ogc_fid_seq; Type: SEQUENCE SET; Schema: test; Owner: -
152--
153
154SELECT pg_catalog.setval('test3_ogc_fid_seq', 6, true);
155
156
157--
158-- Name: test1_pkey; Type: CONSTRAINT; Schema: test; Owner: -
159--
160
161ALTER TABLE ONLY test1
162 ADD CONSTRAINT test1_pkey PRIMARY KEY (id);
163
164
165--
166-- Name: test2_pkey; Type: CONSTRAINT; Schema: test; Owner: -
167--
168
169ALTER TABLE ONLY test2
170 ADD CONSTRAINT test2_pkey PRIMARY KEY (id);
171
172
173--
174-- PostgreSQL database dump complete
175--