Skip to content

Instantly share code, notes, and snippets.

@zimmicz
Created September 21, 2016 17:53
Show Gist options
  • Save zimmicz/58753e6fe40a77089b86ff90df571c18 to your computer and use it in GitHub Desktop.
Save zimmicz/58753e6fe40a77089b86ff90df571c18 to your computer and use it in GitHub Desktop.
--
-- 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: test_disjoint; Type: TABLE; Schema: test; Owner: -
--
CREATE TABLE test_disjoint (
id integer NOT NULL,
geom public.geometry(Point,5514)
);
--
-- Name: test_disjoint_id_seq; Type: SEQUENCE; Schema: test; Owner: -
--
CREATE SEQUENCE test_disjoint_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: test_disjoint_id_seq; Type: SEQUENCE OWNED BY; Schema: test; Owner: -
--
ALTER SEQUENCE test_disjoint_id_seq OWNED BY test_disjoint.id;
--
-- Name: id; Type: DEFAULT; Schema: test; Owner: -
--
ALTER TABLE ONLY test_disjoint ALTER COLUMN id SET DEFAULT nextval('test_disjoint_id_seq'::regclass);
--
-- Data for Name: test_disjoint; Type: TABLE DATA; Schema: test; Owner: -
--
COPY test_disjoint (id, geom) FROM stdin;
1 01010000208A150000001E124B9E2622C1752ACE0FCAB331C1
2 01010000208A150000A51B6224272722C1B9D43790E6B431C1
3 01010000208A150000574F41B5972422C18B1D71A6A9B331C1
4 01010000208A15000041A62FC8362322C15615748A77B231C1
5 01010000208A150000419FF52AAF1E22C191B838821DB231C1
6 01010000208A1500008DF8FE4FB41922C164B7E0EE61B231C1
7 01010000208A150000DBC41FBF431C22C139D19AC1A2B231C1
8 01010000208A150000822E4D45CF1F22C1A546380982B331C1
9 01010000208A1500009A3C0242AB1F22C1F25CEA2190B431C1
10 01010000208A150000E0017E28C42022C1E9F0A1899EB431C1
11 01010000208A150000C787EB7EE51D22C1F1A67BCB0EB331C1
12 01010000208A15000029987ACB5A2322C1ECC122461CB631C1
13 01010000208A15000076FFF72A6F2722C1254AD5D7C5B531C1
14 01010000208A15000041AD6965BE2722C18102F454BEB631C1
15 01010000208A15000098D02495A81C22C1BCA5B84C64B631C1
16 01010000208A15000016B9AFFDEF1E22C1C1DBDC185DB631C1
17 01010000208A15000071BB5F24671E22C1524B2D6B81B531C1
18 01010000208A1500002017845BD21522C1B9D43790E6B431C1
19 01010000208A15000089C2DA83BB1922C19EF501D78CB331C1
20 01010000208A1500006F4F8277641B22C17A60F2DBC2B331C1
21 01010000208A150000318A717C3A1722C1BF6FFF6B5AB331C1
22 01010000208A150000848CB6B7C21922C197A4CBA497B331C1
23 01010000208A15000034622CD63F1D22C12279541B48B431C1
24 01010000208A150000CBCB8385ED2622C139D8D45E2AB731C1
25 01010000208A1500007A351CF7672722C11543C56360B731C1
26 01010000208A150000BCC47311882822C140290B911FB731C1
27 01010000208A1500006A2E0C83022922C106EBE9A8F4B531C1
28 01010000208A150000A4B6BE14AC2822C1A1C682930AB531C1
29 01010000208A1500003B12A2894A2922C12494668144B431C1
30 01010000208A150000ED45811ABB2622C1079A1E62EEB231C1
31 01010000208A150000AD1BCD0F162422C1153C8BC6D8B231C1
32 01010000208A1500000017D8AD162222C1B3E8A46D6CB331C1
33 01010000208A150000399F8A3FC02122C1FEE344207EB431C1
34 01010000208A1500001BEFD3C9E81E22C19324162F20B531C1
35 01010000208A1500001C5477D9631D22C16308AC3568B531C1
36 01010000208A1500002C5B874DC91B22C1683ED00161B531C1
\.
--
-- Name: test_disjoint_id_seq; Type: SEQUENCE SET; Schema: test; Owner: -
--
SELECT pg_catalog.setval('test_disjoint_id_seq', 36, true);
--
-- Name: test_disjoint_pkey; Type: CONSTRAINT; Schema: test; Owner: -
--
ALTER TABLE ONLY test_disjoint
ADD CONSTRAINT test_disjoint_pkey PRIMARY KEY (id);
--
-- PostgreSQL database dump complete
--
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment