--
-- PostgreSQL database dump
--

\connect - rbt

SET search_path = public, pg_catalog;

--
-- TOC entry 8 (OID 16991)
-- Name: a; Type: TABLE; Schema: public; Owner: rbt
--

CREATE TABLE a (
    col integer,
    col1 serial NOT NULL,
    col32 text
);


--
-- TOC entry 9 (OID 17003)
-- Name: b; Type: TABLE; Schema: public; Owner: rbt
--

CREATE TABLE b (
    col serial NOT NULL,
    col2 bigserial NOT NULL,
    col3 serial NOT NULL
);


--
-- TOC entry 6 (OID 17011)
-- Name: stuff; Type: SEQUENCE; Schema: public; Owner: rbt
--

CREATE SEQUENCE stuff
    START 1
    INCREMENT 1
    MAXVALUE 9223372036854775807
    MINVALUE 1
    CACHE 1;


--
-- TOC entry 10 (OID 17013)
-- Name: c; Type: TABLE; Schema: public; Owner: rbt
--

CREATE TABLE c (
    colu integer DEFAULT nextval('stuff'::text)
);


--
-- Data for TOC entry 12 (OID 16991)
-- Name: a; Type: TABLE DATA; Schema: public; Owner: rbt
--

COPY a (col, col1, col32) FROM stdin;
\.


--
-- Data for TOC entry 13 (OID 17003)
-- Name: b; Type: TABLE DATA; Schema: public; Owner: rbt
--

COPY b (col, col2, col3) FROM stdin;
1	1	1
\.


--
-- Data for TOC entry 14 (OID 17013)
-- Name: c; Type: TABLE DATA; Schema: public; Owner: rbt
--

COPY c (colu) FROM stdin;
\.


--
-- TOC entry 11 (OID 17008)
-- Name: b_col3_key; Type: CONSTRAINT; Schema: public; Owner: rbt
--

ALTER TABLE ONLY b
    ADD CONSTRAINT b_col3_key UNIQUE (col3);


--
-- TOC entry 2 (OID 16989)
-- Name: a_col1_seq; Type: SEQUENCE SET; Schema: public; Owner: rbt
--

SELECT pg_catalog.setval ('a_col1_seq', 1, false);


--
-- TOC entry 3 (OID 16997)
-- Name: b_col_seq; Type: SEQUENCE SET; Schema: public; Owner: rbt
--

SELECT pg_catalog.setval ('b_col_seq', 1, true);


--
-- TOC entry 4 (OID 16999)
-- Name: b_col2_seq; Type: SEQUENCE SET; Schema: public; Owner: rbt
--

SELECT pg_catalog.setval ('b_col2_seq', 1, true);


--
-- TOC entry 5 (OID 17001)
-- Name: b_col3_seq; Type: SEQUENCE SET; Schema: public; Owner: rbt
--

SELECT pg_catalog.setval ('b_col3_seq', 1, true);


--
-- TOC entry 7 (OID 17011)
-- Name: stuff; Type: SEQUENCE SET; Schema: public; Owner: rbt
--

SELECT pg_catalog.setval ('stuff', 1, false);