--
--

\connect - chriskl

--
-- TOC entry 2 (OID 2200)
-- Name: public; Type: ACL; Schema: -; Owner: chriskl
--

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


\connect - bob


--
-- TOC entry 3 (OID 935665)
-- Name: parent; Type: TABLE; Schema: public; Owner: bob
--

CREATE TABLE parent (
    a integer NOT NULL
);


\connect - sue


--
-- TOC entry 4 (OID 935669)
-- Name: child; Type: TABLE; Schema: public; Owner: sue
--

CREATE TABLE child (
    b integer
);


\connect - bob


--
-- Data for TOC entry 6 (OID 935665)
-- Name: parent; Type: TABLE DATA; Schema: public; Owner: bob
--

COPY parent (a) FROM stdin;
\.


\connect - sue


--
-- Data for TOC entry 7 (OID 935669)
-- Name: child; Type: TABLE DATA; Schema: public; Owner: sue
--

COPY child (b) FROM stdin;
\.


\connect - bob


--
-- TOC entry 5 (OID 935667)
-- Name: parent_pkey; Type: CONSTRAINT; Schema: public; Owner: bob
--

ALTER TABLE ONLY parent
    ADD CONSTRAINT parent_pkey PRIMARY KEY (a);


\connect - sue


--
-- TOC entry 8 (OID 935671)
-- Name: $1; Type: CONSTRAINT; Schema: public; Owner: sue
--

ALTER TABLE ONLY child
    ADD CONSTRAINT "$1" FOREIGN KEY (b) REFERENCES parent(a);


