-- -- PostgreSQL database dump -- SET SESSION AUTHORIZATION 'postgres'; -- -- TOC entry 3 (OID 2200) -- Name: public; Type: ACL; Schema: -; Owner: postgres -- REVOKE ALL ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; SET SESSION AUTHORIZATION 'testuser'; SET search_path = public, pg_catalog; -- -- TOC entry 4 (OID 17144) -- Name: pga_graphs; Type: TABLE; Schema: public; Owner: testuser -- CREATE TABLE pga_graphs ( graphname character varying(64) NOT NULL, graphsource text, graphcode text ); -- -- TOC entry 5 (OID 17151) -- Name: pga_layout; Type: TABLE; Schema: public; Owner: testuser -- CREATE TABLE pga_layout ( tablename character varying(64) NOT NULL, nrcols smallint, colnames text, colwidth text ); -- -- TOC entry 6 (OID 17158) -- Name: pga_images; Type: TABLE; Schema: public; Owner: testuser -- CREATE TABLE pga_images ( imagename character varying(64) NOT NULL, imagesource text ); -- -- TOC entry 7 (OID 17165) -- Name: pga_queries; Type: TABLE; Schema: public; Owner: testuser -- CREATE TABLE pga_queries ( queryname character varying(64) NOT NULL, querytype character(1), querycommand text, querytables text, querylinks text, queryresults text, querycomments text ); -- -- TOC entry 8 (OID 17172) -- Name: pga_reports; Type: TABLE; Schema: public; Owner: testuser -- CREATE TABLE pga_reports ( reportname character varying(64) NOT NULL, reportsource text, reportbody text, reportprocs text, reportoptions text ); -- -- TOC entry 9 (OID 17179) -- Name: pga_forms; Type: TABLE; Schema: public; Owner: testuser -- CREATE TABLE pga_forms ( formname character varying(64) NOT NULL, formsource text ); -- -- TOC entry 10 (OID 17186) -- Name: pga_diagrams; Type: TABLE; Schema: public; Owner: testuser -- CREATE TABLE pga_diagrams ( diagramname character varying(64) NOT NULL, diagramtables text, diagramlinks text ); -- -- TOC entry 11 (OID 17193) -- Name: pga_scripts; Type: TABLE; Schema: public; Owner: testuser -- CREATE TABLE pga_scripts ( scriptname character varying(64) NOT NULL, scriptsource text ); SET SESSION AUTHORIZATION 'postgres'; -- -- TOC entry 12 (OID 17201) -- Name: testdata; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE testdata ( foo character varying(25), bar character varying(25), id integer ); SET SESSION AUTHORIZATION 'testuser'; -- -- Data for TOC entry 21 (OID 17144) -- Name: pga_graphs; Type: TABLE DATA; Schema: public; Owner: testuser -- COPY pga_graphs (graphname, graphsource, graphcode) FROM stdin; \. -- -- Data for TOC entry 22 (OID 17151) -- Name: pga_layout; Type: TABLE DATA; Schema: public; Owner: testuser -- COPY pga_layout (tablename, nrcols, colnames, colwidth) FROM stdin; information_schema.sql_features 7 feature_id feature_name sub_feature_id sub_feature_name is_supported is_verified_by comments 150 150 150 150 150 150 150 public.testdata 3 foo bar {id} 150 150 150 \. -- -- Data for TOC entry 23 (OID 17158) -- Name: pga_images; Type: TABLE DATA; Schema: public; Owner: testuser -- COPY pga_images (imagename, imagesource) FROM stdin; \. -- -- Data for TOC entry 24 (OID 17165) -- Name: pga_queries; Type: TABLE DATA; Schema: public; Owner: testuser -- COPY pga_queries (queryname, querytype, querycommand, querytables, querylinks, queryresults, querycomments) FROM stdin; \. -- -- Data for TOC entry 25 (OID 17172) -- Name: pga_reports; Type: TABLE DATA; Schema: public; Owner: testuser -- COPY pga_reports (reportname, reportsource, reportbody, reportprocs, reportoptions) FROM stdin; \. -- -- Data for TOC entry 26 (OID 17179) -- Name: pga_forms; Type: TABLE DATA; Schema: public; Owner: testuser -- COPY pga_forms (formname, formsource) FROM stdin; \. -- -- Data for TOC entry 27 (OID 17186) -- Name: pga_diagrams; Type: TABLE DATA; Schema: public; Owner: testuser -- COPY pga_diagrams (diagramname, diagramtables, diagramlinks) FROM stdin; \. -- -- Data for TOC entry 28 (OID 17193) -- Name: pga_scripts; Type: TABLE DATA; Schema: public; Owner: testuser -- COPY pga_scripts (scriptname, scriptsource) FROM stdin; \. SET SESSION AUTHORIZATION 'postgres'; -- -- Data for TOC entry 29 (OID 17201) -- Name: testdata; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY testdata (foo, bar, id) FROM stdin; fooname barname \N \. SET SESSION AUTHORIZATION 'testuser'; -- -- TOC entry 13 (OID 17149) -- Name: pga_graphs_pkey; Type: CONSTRAINT; Schema: public; Owner: testuser -- ALTER TABLE ONLY pga_graphs ADD CONSTRAINT pga_graphs_pkey PRIMARY KEY (graphname); -- -- TOC entry 14 (OID 17156) -- Name: pga_layout_pkey; Type: CONSTRAINT; Schema: public; Owner: testuser -- ALTER TABLE ONLY pga_layout ADD CONSTRAINT pga_layout_pkey PRIMARY KEY (tablename); -- -- TOC entry 15 (OID 17163) -- Name: pga_images_pkey; Type: CONSTRAINT; Schema: public; Owner: testuser -- ALTER TABLE ONLY pga_images ADD CONSTRAINT pga_images_pkey PRIMARY KEY (imagename); -- -- TOC entry 16 (OID 17170) -- Name: pga_queries_pkey; Type: CONSTRAINT; Schema: public; Owner: testuser -- ALTER TABLE ONLY pga_queries ADD CONSTRAINT pga_queries_pkey PRIMARY KEY (queryname); -- -- TOC entry 17 (OID 17177) -- Name: pga_reports_pkey; Type: CONSTRAINT; Schema: public; Owner: testuser -- ALTER TABLE ONLY pga_reports ADD CONSTRAINT pga_reports_pkey PRIMARY KEY (reportname); -- -- TOC entry 18 (OID 17184) -- Name: pga_forms_pkey; Type: CONSTRAINT; Schema: public; Owner: testuser -- ALTER TABLE ONLY pga_forms ADD CONSTRAINT pga_forms_pkey PRIMARY KEY (formname); -- -- TOC entry 19 (OID 17191) -- Name: pga_diagrams_pkey; Type: CONSTRAINT; Schema: public; Owner: testuser -- ALTER TABLE ONLY pga_diagrams ADD CONSTRAINT pga_diagrams_pkey PRIMARY KEY (diagramname); -- -- TOC entry 20 (OID 17198) -- Name: pga_scripts_pkey; Type: CONSTRAINT; Schema: public; Owner: testuser -- ALTER TABLE ONLY pga_scripts ADD CONSTRAINT pga_scripts_pkey PRIMARY KEY (scriptname); SET SESSION AUTHORIZATION 'postgres'; -- -- TOC entry 2 (OID 2200) -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres -- COMMENT ON SCHEMA public IS 'Standard public schema';