--
-- PostgreSQL database dump
--

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 = public, pg_catalog;

--
-- Name: pgpool_pgctl(text, text); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION pgpool_pgctl(text, text) RETURNS boolean
    LANGUAGE c STRICT
    AS '$libdir/pgpool-recovery', 'pgpool_pgctl';


ALTER FUNCTION public.pgpool_pgctl(text, text) OWNER TO postgres;

--
-- Name: pgpool_recovery(text, text, text); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION pgpool_recovery(text, text, text) RETURNS boolean
    LANGUAGE c STRICT
    AS '$libdir/pgpool-recovery', 'pgpool_recovery';


ALTER FUNCTION public.pgpool_recovery(text, text, text) OWNER TO postgres;

--
-- Name: pgpool_remote_start(text, text); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION pgpool_remote_start(text, text) RETURNS boolean
    LANGUAGE c STRICT
    AS '$libdir/pgpool-recovery', 'pgpool_remote_start';


ALTER FUNCTION public.pgpool_remote_start(text, text) OWNER TO postgres;

--
-- Name: pgpool_switch_xlog(text); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION pgpool_switch_xlog(text) RETURNS text
    LANGUAGE c STRICT
    AS '$libdir/pgpool-recovery', 'pgpool_switch_xlog';


ALTER FUNCTION public.pgpool_switch_xlog(text) OWNER TO postgres;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: primary_table; Type: TABLE; Schema: public; Owner: adrian; Tablespace: 
--

CREATE TABLE primary_table (
    id integer NOT NULL,
    uid character varying(100)
);


ALTER TABLE public.primary_table OWNER TO adrian;

--
-- Name: primary_table_id_seq; Type: SEQUENCE; Schema: public; Owner: adrian
--

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


ALTER TABLE public.primary_table_id_seq OWNER TO adrian;

--
-- Name: primary_table_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: adrian
--

ALTER SEQUENCE primary_table_id_seq OWNED BY primary_table.id;


--
-- Name: secondary_table; Type: TABLE; Schema: public; Owner: adrian; Tablespace: 
--

CREATE TABLE secondary_table (
    id integer NOT NULL,
    primary_id integer NOT NULL,
    oth_info character varying NOT NULL
);


ALTER TABLE public.secondary_table OWNER TO adrian;

--
-- Name: secondary table_id_seq; Type: SEQUENCE; Schema: public; Owner: adrian
--

CREATE SEQUENCE "secondary table_id_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public."secondary table_id_seq" OWNER TO adrian;

--
-- Name: secondary table_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: adrian
--

ALTER SEQUENCE "secondary table_id_seq" OWNED BY secondary_table.id;


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: adrian
--

ALTER TABLE ONLY primary_table ALTER COLUMN id SET DEFAULT nextval('primary_table_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: adrian
--

ALTER TABLE ONLY secondary_table ALTER COLUMN id SET DEFAULT nextval('"secondary table_id_seq"'::regclass);


--
-- Data for Name: primary_table; Type: TABLE DATA; Schema: public; Owner: adrian
--

INSERT INTO primary_table VALUES (1, '{9B0E4603-28A6-44EA-B8AA-7B94540812C0}');
INSERT INTO primary_table VALUES (2, '{52575E31-2579-DFD4-F275-00AC9D39BCC3}');
INSERT INTO primary_table VALUES (3, '{EC626488-9F34-A853-E9AA-70D30F9C0B78}');
INSERT INTO primary_table VALUES (4, '{04209885-7771-02BF-AF44-72382B30E6B4}');
INSERT INTO primary_table VALUES (5, '{50F6A9DA-7F12-2C10-D0C6-A597379F690F}');


--
-- Name: primary_table_id_seq; Type: SEQUENCE SET; Schema: public; Owner: adrian
--

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


--
-- Name: secondary table_id_seq; Type: SEQUENCE SET; Schema: public; Owner: adrian
--

SELECT pg_catalog.setval('"secondary table_id_seq"', 7, true);


--
-- Data for Name: secondary_table; Type: TABLE DATA; Schema: public; Owner: adrian
--

INSERT INTO secondary_table VALUES (2, 1, 'oha');
INSERT INTO secondary_table VALUES (3, 2, 'oha');
INSERT INTO secondary_table VALUES (4, 3, 'oha');
INSERT INTO secondary_table VALUES (5, 4, 'oha');
INSERT INTO secondary_table VALUES (6, 5, 'oha');


--
-- Name: primary_table_pkey; Type: CONSTRAINT; Schema: public; Owner: adrian; Tablespace: 
--

ALTER TABLE ONLY primary_table
    ADD CONSTRAINT primary_table_pkey PRIMARY KEY (id);


--
-- Name: secondary table_pkey; Type: CONSTRAINT; Schema: public; Owner: adrian; Tablespace: 
--

ALTER TABLE ONLY secondary_table
    ADD CONSTRAINT "secondary table_pkey" PRIMARY KEY (id);


--
-- Name: secondary table_primary_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: adrian
--

ALTER TABLE ONLY secondary_table
    ADD CONSTRAINT "secondary table_primary_id_fkey" FOREIGN KEY (primary_id) REFERENCES primary_table(id);


--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- PostgreSQL database dump complete