03_st_difference.sql

DROP SCHEMA IF EXISTS test;
CREATE SCHEMA test;
--
-- PostgreSQL database dump
--

-- Dumped from database version 9.5.4
-- Dumped by pg_dump version 9.5.4

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

SET search_path = test, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: test1; Type: TABLE; Schema: test; Owner: -
--

CREATE TABLE test1 (
    id integer NOT NULL,
    geom public.geometry(Polygon,5514)
);


--
-- Name: test1_id_seq; Type: SEQUENCE; Schema: test; Owner: -
--

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


--
-- Name: test1_id_seq; Type: SEQUENCE OWNED BY; Schema: test; Owner: -
--

ALTER SEQUENCE test1_id_seq OWNED BY test1.id;


--
-- Name: test2; Type: TABLE; Schema: test; Owner: -
--

CREATE TABLE test2 (
    id integer NOT NULL,
    geom public.geometry(Polygon,5514)
);


--
-- Name: test2_id_seq; Type: SEQUENCE; Schema: test; Owner: -
--

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


--
-- Name: test2_id_seq; Type: SEQUENCE OWNED BY; Schema: test; Owner: -
--

ALTER SEQUENCE test2_id_seq OWNED BY test2.id;


--
-- Name: test3_ogc_fid_seq; Type: SEQUENCE; Schema: test; Owner: -
--

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


--
-- Name: id; Type: DEFAULT; Schema: test; Owner: -
--

ALTER TABLE ONLY test1 ALTER COLUMN id SET DEFAULT nextval('test1_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: test; Owner: -
--

ALTER TABLE ONLY test2 ALTER COLUMN id SET DEFAULT nextval('test2_id_seq'::regclass);


--
-- Data for Name: test1; Type: TABLE DATA; Schema: test; Owner: -
--

COPY test1 (id, geom) FROM stdin;
1	01030000208A1500000100000006000000951452B0C12822C12494668144B431C16EF852A2F82522C1CBF6596A48B331C1CA5FA6D8EA2322C16CBE8577D8B331C1CD302795682522C1804C85FE3CB531C13C774599C52722C19FAB702D0EB531C1951452B0C12822C12494668144B431C1
2	01030000208A1500000100000008000000AD1493728E1F22C184CC3A74B4B331C1D0F33317D71D22C1B9D43790E6B431C157480718102022C14BFAF6388CB531C194A13A66372122C105357B5273B431C15F4FACA0862122C1C28A11D256B331C1822E4D45CF1F22C11A72AF92D1B231C159ADAA278B1E22C124DEF72AC3B231C1AD1493728E1F22C184CC3A74B4B331C1
3	01030000208A1500000100000009000000547EC0F8192322C12014B10BCDB531C191D7F346412422C1D4B36D4940B631C1F00FC839B12322C1477A41C314B731C1054DFC790F2222C139D8D45E2AB731C1B51B38FB042122C14FCB77F509B731C1A779CB961A2122C1D2985BE343B631C1303342A7CE2122C147C4D26C93B531C1BD22DD837B2222C176E03C664BB531C1547EC0F8192322C12014B10BCDB531C1
4	01030000208A15000001000000080000009243D1F3432722C1EEDC34AC18B631C1B78E4F458F2822C194DA8485A1B631C116C72338FF2722C1E8416DD0A4B731C121980FE06B2622C1E6265B6AA8B731C1E53EDC91442522C1F2ADB56896B731C1BA589664852522C1A061DF838FB631C16EF852A2F82522C1F312597811B631C19243D1F3432722C1EEDC34AC18B631C1
5	01030000208A150000010000000800000095FFA3D82A1B22C1DB04A47B35B631C1D3BD7A36CD1A22C1F25CEA2190B431C1144698B3651722C1EE26C65597B431C161A6DB75F21622C1524B2D6B81B531C123E80418501722C1CF7D497D47B631C1CBB6D5AD561922C1C1DBDC185DB631C171B42587DF1922C14BFAF6388CB531C195FFA3D82A1B22C1DB04A47B35B631C1
\.


--
-- Name: test1_id_seq; Type: SEQUENCE SET; Schema: test; Owner: -
--

SELECT pg_catalog.setval('test1_id_seq', 5, true);


--
-- Data for Name: test2; Type: TABLE DATA; Schema: test; Owner: -
--

COPY test2 (id, geom) FROM stdin;
1	01030000208A1500000100000007000000BF8EBA307E2522C11FA8D35ECAB231C1C3C4DEFC762522C1C28A11D256B331C12B0458785D2622C19489B93E9BB331C136D54320CA2422C12494668144B431C11BF60D67702322C1031A69EC76B431C141A62FC8362322C1C9DB47044CB331C1BF8EBA307E2522C11FA8D35ECAB231C1
2	01030000208A15000001000000080000009A433CDF322422C1428EAEA09AB531C18D06738AC32222C19FAB702D0EB531C118258DAAF22122C1B7B9252AEAB431C1775D619D622122C1578151377AB531C1303342A7CE2122C119C37AD9D7B531C141A62FC8362322C10906FC0EF1B531C179C93E4A652422C1148D560DDFB531C19A433CDF322422C1428EAEA09AB531C1
3	01030000208A15000001000000070000004C70E1D21B1D22C1F577FC878CB431C1A506B44C901922C13CA21B7E20B431C19DFF0EC4191822C189025F40ADB331C13BF6B9142C1722C1B068EFF7F4B431C1345BF238B81822C117A86873DBB531C15F487203FF1C22C1360754A2ACB531C14C70E1D21B1D22C1F577FC878CB431C1
4	01030000208A1500000100000006000000ACBD639D222A22C1524B2D6B81B531C1722E776EF12522C149DFE4D28FB531C1A24AE167A92522C17EE7E1EEC1B631C1951452B0C12822C18FA460B9A8B631C17235B10B792A22C19B2BBBB796B631C1ACBD639D222A22C1524B2D6B81B531C1
5	01030000208A15000001000000070000004EDCBE7F1E2022C196EE5C4E16B231C1D7953590D22022C1E83A33331DB331C1FEAAFA00141F22C1AFB280A173B331C1B779A16DF81A22C1FD2DD6C9FCB231C1F808F987181C22C1ACE1FFE4F5B131C159ADAA278B1E22C1E24EA010A3B131C14EDCBE7F1E2022C196EE5C4E16B231C1
6	01030000208A15000001000000060000008DFF38ED3B1E22C1CF7D497D47B631C1DA584212411922C1185ED7C95CB731C12EC02A5D441A22C181B862AB3FB831C1419FF52AAF1E22C16AAAADAE63B831C13198E5B6492022C1D033B8D3C8B731C18DFF38ED3B1E22C1CF7D497D47B631C1
7	01030000208A150000010000000700000047483141322622C14829767C0EB431C1A0E53D582E2722C14829767C0EB431C17F6B40C3602722C1F9AD205485B431C1F27BA5E6B32622C1CA91B65ACDB431C194A87403BF2522C1C776A4F4D0B431C1ACB629009B2522C1205E42B54BB431C147483141322622C14829767C0EB431C1
\.


--
-- Name: test2_id_seq; Type: SEQUENCE SET; Schema: test; Owner: -
--

SELECT pg_catalog.setval('test2_id_seq', 7, true);


--
-- Name: test3_ogc_fid_seq; Type: SEQUENCE SET; Schema: test; Owner: -
--

SELECT pg_catalog.setval('test3_ogc_fid_seq', 6, true);


--
-- Name: test1_pkey; Type: CONSTRAINT; Schema: test; Owner: -
--

ALTER TABLE ONLY test1
    ADD CONSTRAINT test1_pkey PRIMARY KEY (id);


--
-- Name: test2_pkey; Type: CONSTRAINT; Schema: test; Owner: -
--

ALTER TABLE ONLY test2
    ADD CONSTRAINT test2_pkey PRIMARY KEY (id);


--
-- PostgreSQL database dump complete
--