remote_db.sql

text/plain

Download

--
-- PostgreSQL database dump
--

-- Dumped from database version 11.3
-- Dumped by pg_dump version 11.3

-- Started on 2019-06-18 12:01:33

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- TOC entry 4285 (class 1262 OID 619363)
-- Name: remote; Type: DATABASE; Schema: -; Owner: postgres
--

CREATE DATABASE remote WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'English_United States.1252' LC_CTYPE = 'English_United States.1252';


ALTER DATABASE remote OWNER TO postgres;

\connect remote

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- TOC entry 10 (class 2615 OID 620949)
-- Name: remote; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA remote;


ALTER SCHEMA remote OWNER TO postgres;

--
-- TOC entry 3 (class 3079 OID 619365)
-- Name: postgis; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA public;


--
-- TOC entry 4286 (class 0 OID 0)
-- Dependencies: 3
-- Name: EXTENSION postgis; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION postgis IS 'PostGIS geometry, geography, and raster spatial types and functions';


--
-- TOC entry 2 (class 3079 OID 620945)
-- Name: postgres_fdw; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS postgres_fdw WITH SCHEMA public;


--
-- TOC entry 4287 (class 0 OID 0)
-- Dependencies: 2
-- Name: EXTENSION postgres_fdw; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION postgres_fdw IS 'foreign-data wrapper for remote PostgreSQL servers';


SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 215 (class 1259 OID 620952)
-- Name: locations; Type: TABLE; Schema: remote; Owner: postgres
--

CREATE TABLE remote.locations (
    id bigint NOT NULL,
    name character varying,
    lonlat public.geometry NOT NULL
);


ALTER TABLE remote.locations OWNER TO postgres;

--
-- TOC entry 214 (class 1259 OID 620950)
-- Name: locations_id_seq; Type: SEQUENCE; Schema: remote; Owner: postgres
--

CREATE SEQUENCE remote.locations_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE remote.locations_id_seq OWNER TO postgres;

--
-- TOC entry 4288 (class 0 OID 0)
-- Dependencies: 214
-- Name: locations_id_seq; Type: SEQUENCE OWNED BY; Schema: remote; Owner: postgres
--

ALTER SEQUENCE remote.locations_id_seq OWNED BY remote.locations.id;


--
-- TOC entry 4145 (class 2604 OID 620955)
-- Name: locations id; Type: DEFAULT; Schema: remote; Owner: postgres
--

ALTER TABLE ONLY remote.locations ALTER COLUMN id SET DEFAULT nextval('remote.locations_id_seq'::regclass);


--
-- TOC entry 4143 (class 0 OID 619675)
-- Dependencies: 200
-- Data for Name: spatial_ref_sys; Type: TABLE DATA; Schema: public; Owner: postgres
--



--
-- TOC entry 4279 (class 0 OID 620952)
-- Dependencies: 215
-- Data for Name: locations; Type: TABLE DATA; Schema: remote; Owner: postgres
--



--
-- TOC entry 4289 (class 0 OID 0)
-- Dependencies: 214
-- Name: locations_id_seq; Type: SEQUENCE SET; Schema: remote; Owner: postgres
--

SELECT pg_catalog.setval('remote.locations_id_seq', 1, false);


--
-- TOC entry 4149 (class 2606 OID 620960)
-- Name: locations locations_pkey; Type: CONSTRAINT; Schema: remote; Owner: postgres
--

ALTER TABLE ONLY remote.locations
    ADD CONSTRAINT locations_pkey PRIMARY KEY (id);


-- Completed on 2019-06-18 12:01:37

--
-- PostgreSQL database dump complete
--