--
-- PostgreSQL database dump
--

SET client_encoding = 'SQL_ASCII';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

SET search_path = ss, pg_catalog;

DROP TABLE ss.x;
DROP SCHEMA tt;
DROP SCHEMA ss;
DROP SCHEMA public;
--
-- Name: public; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA public;


ALTER SCHEMA public OWNER TO postgres;

--
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA public IS 'standard public schema';


--
-- Name: ss; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA ss;


ALTER SCHEMA ss OWNER TO postgres;

--
-- Name: tt; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA tt;


ALTER SCHEMA tt OWNER TO postgres;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: x; Type: TABLE; Schema: ss; Owner: postgres; Tablespace: 
--

CREATE TABLE x (
    y integer
);


ALTER TABLE ss.x OWNER TO postgres;

--
-- Data for Name: x; Type: TABLE DATA; Schema: ss; Owner: postgres
--

COPY x (y) FROM stdin;
\.


--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- PostgreSQL database dump complete
--