2
-- PostgreSQL database dump
5
SET client_encoding = 'UTF8';
6
SET standard_conforming_strings = off;
7
SET check_function_bodies = false;
8
SET client_min_messages = warning;
9
SET escape_string_warning = off;
12
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
15
COMMENT ON SCHEMA public IS 'Standard public schema';
19
-- Name: testschema2; Type: SCHEMA; Schema: -; Owner: fordfrog
22
CREATE SCHEMA testschema2;
25
ALTER SCHEMA testschema2 OWNER TO fordfrog;
27
SET search_path = public, pg_catalog;
29
SET default_tablespace = '';
31
SET default_with_oids = false;
34
-- Name: testtable1; Type: TABLE; Schema: public; Owner: fordfrog; Tablespace:
37
CREATE TABLE testtable1 (
42
ALTER TABLE public.testtable1 OWNER TO fordfrog;
45
-- Name: testtable1_id_seq; Type: SEQUENCE; Schema: public; Owner: fordfrog
48
CREATE SEQUENCE testtable1_id_seq
56
ALTER TABLE public.testtable1_id_seq OWNER TO fordfrog;
59
-- Name: testtable1_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: fordfrog
62
ALTER SEQUENCE testtable1_id_seq OWNED BY testtable1.id;
66
-- Name: testtable1_id_seq; Type: SEQUENCE SET; Schema: public; Owner: fordfrog
69
SELECT pg_catalog.setval('testtable1_id_seq', 1, false);
73
-- Name: testtable3; Type: TABLE; Schema: public; Owner: fordfrog; Tablespace:
76
CREATE TABLE testtable3 (
81
ALTER TABLE public.testtable3 OWNER TO fordfrog;
84
-- Name: testtable3_id_seq; Type: SEQUENCE; Schema: public; Owner: fordfrog
87
CREATE SEQUENCE testtable3_id_seq
95
ALTER TABLE public.testtable3_id_seq OWNER TO fordfrog;
98
-- Name: testtable3_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: fordfrog
101
ALTER SEQUENCE testtable3_id_seq OWNED BY testtable3.id;
105
-- Name: testtable3_id_seq; Type: SEQUENCE SET; Schema: public; Owner: fordfrog
108
SELECT pg_catalog.setval('testtable3_id_seq', 1, false);
111
SET search_path = testschema2, pg_catalog;
114
-- Name: testtable1; Type: TABLE; Schema: testschema2; Owner: fordfrog; Tablespace:
117
CREATE TABLE testtable1 (
122
ALTER TABLE testschema2.testtable1 OWNER TO fordfrog;
125
-- Name: testtable1_id_seq; Type: SEQUENCE; Schema: testschema2; Owner: fordfrog
128
CREATE SEQUENCE testtable1_id_seq
136
ALTER TABLE testschema2.testtable1_id_seq OWNER TO fordfrog;
139
-- Name: testtable1_id_seq; Type: SEQUENCE OWNED BY; Schema: testschema2; Owner: fordfrog
142
ALTER SEQUENCE testtable1_id_seq OWNED BY testtable1.id;
146
-- Name: testtable1_id_seq; Type: SEQUENCE SET; Schema: testschema2; Owner: fordfrog
149
SELECT pg_catalog.setval('testtable1_id_seq', 1, false);
152
SET search_path = public, pg_catalog;
155
-- Name: id; Type: DEFAULT; Schema: public; Owner: fordfrog
158
ALTER TABLE testtable1 ALTER COLUMN id SET DEFAULT nextval('testtable1_id_seq'::regclass);
162
-- Name: id; Type: DEFAULT; Schema: public; Owner: fordfrog
165
ALTER TABLE testtable3 ALTER COLUMN id SET DEFAULT nextval('testtable3_id_seq'::regclass);
168
SET search_path = testschema2, pg_catalog;
171
-- Name: id; Type: DEFAULT; Schema: testschema2; Owner: fordfrog
174
ALTER TABLE testtable1 ALTER COLUMN id SET DEFAULT nextval('testtable1_id_seq'::regclass);
177
SET search_path = public, pg_catalog;
180
-- Data for Name: testtable1; Type: TABLE DATA; Schema: public; Owner: fordfrog
186
-- Data for Name: testtable3; Type: TABLE DATA; Schema: public; Owner: fordfrog
191
SET search_path = testschema2, pg_catalog;
194
-- Data for Name: testtable1; Type: TABLE DATA; Schema: testschema2; Owner: fordfrog
200
-- Name: public; Type: ACL; Schema: -; Owner: postgres
203
REVOKE ALL ON SCHEMA public FROM PUBLIC;
204
REVOKE ALL ON SCHEMA public FROM postgres;
205
GRANT ALL ON SCHEMA public TO postgres;
206
GRANT ALL ON SCHEMA public TO PUBLIC;
210
-- PostgreSQL database dump complete