--
--

\connect - postgres


--
-- TOC entry 2 (OID 20831227)
-- Name: c; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE c (
    c_text text NOT NULL,
    descr text
);


--
-- TOC entry 3 (OID 20831234)
-- Name: d; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE d (
    d_text text NOT NULL,
    descr text
);


--
-- TOC entry 4 (OID 20831263)
-- Name: main; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE main (
    id serial NOT NULL,
    c_text text,
    d_text text
);


--
-- TOC entry 5 (OID 20831281)
-- Name: a; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE a (
    a_id serial NOT NULL,
    id integer
);


--
-- TOC entry 6 (OID 20831292)
-- Name: b; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE b (
    b_id serial NOT NULL,
    id integer
);


--
-- TOC entry 7 (OID 20831303)
-- Name: e; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE e (
    e_id serial NOT NULL,
    id integer
);


--
-- TOC entry 8 (OID 20831314)
-- Name: f; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE f (
    f_id serial NOT NULL,
    id integer
);


--
-- TOC entry 9 (OID 20831325)
-- Name: g; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE g (
    g_id serial NOT NULL,
    id integer
);


--
-- TOC entry 10 (OID 20831336)
-- Name: h; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE h (
    h_id serial NOT NULL,
    id integer
);


--
-- Data for TOC entry 27 (OID 20831227)
-- Name: c; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY c (c_text, descr) FROM stdin;
one	one
two	two
three	three
four	four
five	five
six	six
seven	seven
eight	eight
nine	nine
ten	ten
\.


--
-- Data for TOC entry 28 (OID 20831234)
-- Name: d; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY d (d_text, descr) FROM stdin;
eleven	eleven
twelve	twelve
thirteen	thirteen
fourteen	fourteen
fifteen	fifteen
sixteen	sisteen
seventeen	seventeen
eighteen	eighteen
nineteen	nineteen
twenty	twenty
\.


--
-- Data for TOC entry 29 (OID 20831263)
-- Name: main; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY main (id, c_text, d_text) FROM stdin;
\.


--
-- Data for TOC entry 30 (OID 20831281)
-- Name: a; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY a (a_id, id) FROM stdin;
\.


--
-- Data for TOC entry 31 (OID 20831292)
-- Name: b; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY b (b_id, id) FROM stdin;
\.


--
-- Data for TOC entry 32 (OID 20831303)
-- Name: e; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY e (e_id, id) FROM stdin;
\.


--
-- Data for TOC entry 33 (OID 20831314)
-- Name: f; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY f (f_id, id) FROM stdin;
\.


--
-- Data for TOC entry 34 (OID 20831325)
-- Name: g; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY g (g_id, id) FROM stdin;
\.


--
-- Data for TOC entry 35 (OID 20831336)
-- Name: h; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY h (h_id, id) FROM stdin;
\.


--
-- TOC entry 18 (OID 20831232)
-- Name: c_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY c
    ADD CONSTRAINT c_pkey PRIMARY KEY (c_text);


--
-- TOC entry 19 (OID 20831239)
-- Name: d_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY d
    ADD CONSTRAINT d_pkey PRIMARY KEY (d_text);


--
-- TOC entry 20 (OID 20831269)
-- Name: main_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY main
    ADD CONSTRAINT main_pkey PRIMARY KEY (id);


--
-- TOC entry 36 (OID 20831271)
-- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY main
    ADD CONSTRAINT "$1" FOREIGN KEY (c_text) REFERENCES c(c_text) ON UPDATE NO ACTION ON DELETE NO ACTION;


--
-- TOC entry 37 (OID 20831275)
-- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY main
    ADD CONSTRAINT "$2" FOREIGN KEY (d_text) REFERENCES d(d_text) ON UPDATE NO ACTION ON DELETE NO ACTION;


--
-- TOC entry 21 (OID 20831284)
-- Name: a_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY a
    ADD CONSTRAINT a_pkey PRIMARY KEY (a_id);


--
-- TOC entry 38 (OID 20831286)
-- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY a
    ADD CONSTRAINT "$1" FOREIGN KEY (id) REFERENCES main(id) ON UPDATE NO ACTION ON DELETE NO ACTION;


--
-- TOC entry 22 (OID 20831295)
-- Name: b_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY b
    ADD CONSTRAINT b_pkey PRIMARY KEY (b_id);


--
-- TOC entry 39 (OID 20831297)
-- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY b
    ADD CONSTRAINT "$1" FOREIGN KEY (id) REFERENCES main(id) ON UPDATE NO ACTION ON DELETE NO ACTION;


--
-- TOC entry 23 (OID 20831306)
-- Name: e_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY e
    ADD CONSTRAINT e_pkey PRIMARY KEY (e_id);


--
-- TOC entry 40 (OID 20831308)
-- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY e
    ADD CONSTRAINT "$1" FOREIGN KEY (id) REFERENCES main(id) ON UPDATE NO ACTION ON DELETE NO ACTION;


--
-- TOC entry 24 (OID 20831317)
-- Name: f_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY f
    ADD CONSTRAINT f_pkey PRIMARY KEY (f_id);


--
-- TOC entry 41 (OID 20831319)
-- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY f
    ADD CONSTRAINT "$1" FOREIGN KEY (id) REFERENCES main(id) ON UPDATE NO ACTION ON DELETE NO ACTION;


--
-- TOC entry 25 (OID 20831328)
-- Name: g_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY g
    ADD CONSTRAINT g_pkey PRIMARY KEY (g_id);


--
-- TOC entry 42 (OID 20831330)
-- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY g
    ADD CONSTRAINT "$1" FOREIGN KEY (id) REFERENCES main(id) ON UPDATE NO ACTION ON DELETE NO ACTION;


--
-- TOC entry 26 (OID 20831339)
-- Name: h_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY h
    ADD CONSTRAINT h_pkey PRIMARY KEY (h_id);


--
-- TOC entry 43 (OID 20831341)
-- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY h
    ADD CONSTRAINT "$1" FOREIGN KEY (id) REFERENCES main(id) ON UPDATE NO ACTION ON DELETE NO ACTION;


--
-- TOC entry 11 (OID 20831261)
-- Name: main_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

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


--
-- TOC entry 12 (OID 20831279)
-- Name: a_a_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

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


--
-- TOC entry 13 (OID 20831290)
-- Name: b_b_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

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


--
-- TOC entry 14 (OID 20831301)
-- Name: e_e_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

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


--
-- TOC entry 15 (OID 20831312)
-- Name: f_f_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

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


--
-- TOC entry 16 (OID 20831323)
-- Name: g_g_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

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


--
-- TOC entry 17 (OID 20831334)
-- Name: h_h_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

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


