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 (
30
name character varying(30)
34
ALTER TABLE public.testtable OWNER TO fordfrog;
37
-- Name: testview; Type: VIEW; Schema: public; Owner: fordfrog
40
CREATE VIEW testview AS
41
SELECT testtable.id, testtable.name FROM testtable;
44
ALTER TABLE public.testview OWNER TO fordfrog;
47
-- Data for Name: testtable; Type: TABLE DATA; Schema: public; Owner: fordfrog
53
-- Name: public; Type: ACL; Schema: -; Owner: postgres
56
REVOKE ALL ON SCHEMA public FROM PUBLIC;
57
REVOKE ALL ON SCHEMA public FROM postgres;
58
GRANT ALL ON SCHEMA public TO postgres;
59
GRANT ALL ON SCHEMA public TO PUBLIC;
63
-- PostgreSQL database dump complete