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
col2 character varying(20)
35
ALTER TABLE public.testtable OWNER TO fordfrog;
38
-- Name: testtable_id_seq; Type: SEQUENCE; Schema: public; Owner: fordfrog
41
CREATE SEQUENCE testtable_id_seq
49
ALTER TABLE public.testtable_id_seq OWNER TO fordfrog;
52
-- Name: testtable_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: fordfrog
55
ALTER SEQUENCE testtable_id_seq OWNED BY testtable.id;
59
-- Name: testtable_id_seq; Type: SEQUENCE SET; Schema: public; Owner: fordfrog
62
SELECT pg_catalog.setval('testtable_id_seq', 1, false);
66
-- Name: id; Type: DEFAULT; Schema: public; Owner: fordfrog
69
ALTER TABLE testtable ALTER COLUMN id SET DEFAULT nextval('testtable_id_seq'::regclass);
73
-- Data for Name: testtable; Type: TABLE DATA; Schema: public; Owner: fordfrog
79
-- Name: public; Type: ACL; Schema: -; Owner: postgres
82
REVOKE ALL ON SCHEMA public FROM PUBLIC;
83
REVOKE ALL ON SCHEMA public FROM postgres;
84
GRANT ALL ON SCHEMA public TO postgres;
85
GRANT ALL ON SCHEMA public TO PUBLIC;
89
-- PostgreSQL database dump complete