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';
18
SET search_path = public, pg_catalog;
20
SET default_tablespace = '';
22
SET default_with_oids = false;
25
-- Name: testtable; Type: TABLE; Schema: public; Owner: fordfrog; Tablespace:
28
CREATE TABLE testtable (
31
field3 character varying(150) DEFAULT 'none'::character varying,
32
field4 double precision
36
ALTER TABLE public.testtable OWNER TO fordfrog;
39
-- Name: testtable2; Type: TABLE; Schema: public; Owner: fordfrog; Tablespace:
42
CREATE TABLE testtable2 (
48
ALTER TABLE public.testtable2 OWNER TO fordfrog;
51
-- Name: testtable2_id_seq; Type: SEQUENCE; Schema: public; Owner: fordfrog
54
CREATE SEQUENCE testtable2_id_seq
62
ALTER TABLE public.testtable2_id_seq OWNER TO fordfrog;
65
-- Name: testtable2_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: fordfrog
68
ALTER SEQUENCE testtable2_id_seq OWNED BY testtable2.id;
72
-- Name: testtable2_id_seq; Type: SEQUENCE SET; Schema: public; Owner: fordfrog
75
SELECT pg_catalog.setval('testtable2_id_seq', 1, false);
79
-- Name: id; Type: DEFAULT; Schema: public; Owner: fordfrog
82
ALTER TABLE testtable2 ALTER COLUMN id SET DEFAULT nextval('testtable2_id_seq'::regclass);
86
-- Data for Name: testtable; Type: TABLE DATA; Schema: public; Owner: fordfrog
92
-- Data for Name: testtable2; Type: TABLE DATA; Schema: public; Owner: fordfrog
98
-- Name: testindex; Type: INDEX; Schema: public; Owner: fordfrog; Tablespace:
101
CREATE INDEX testindex ON testtable USING btree (field1);
103
ALTER TABLE testtable CLUSTER ON testindex;
107
-- Name: testtable2_col1; Type: INDEX; Schema: public; Owner: fordfrog; Tablespace:
110
CREATE INDEX testtable2_col1 ON testtable2 USING btree (col1);
112
ALTER TABLE testtable2 CLUSTER ON testtable2_col1;
116
-- Name: public; Type: ACL; Schema: -; Owner: postgres
119
REVOKE ALL ON SCHEMA public FROM PUBLIC;
120
REVOKE ALL ON SCHEMA public FROM postgres;
121
GRANT ALL ON SCHEMA public TO postgres;
122
GRANT ALL ON SCHEMA public TO PUBLIC;
126
-- PostgreSQL database dump complete