--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: person; Type: TABLE; Schema: public; Owner: root; Tablespace: 
--

CREATE TABLE person (
    id integer,
    name character varying(40),
    sex character varying(40),
    age integer,
    open boolean
);


ALTER TABLE person OWNER TO root;

--
-- Name: person2; Type: TABLE; Schema: public; Owner: root; Tablespace: 
--

CREATE TABLE person2 (
    id integer,
    name character varying(40),
    sex character varying(40),
    age integer
);


ALTER TABLE person2 OWNER TO root;

--
-- Data for Name: person; Type: TABLE DATA; Schema: public; Owner: root
--

COPY person (id, name, sex, age, open) FROM stdin;
1	aaa	m	10	t
2	bbb	m	20	f
3	ccc	m	30	f
4	ddd	w	40	f
5	eee	m	50	f
6	fff	w	60	t
7	ggg	w	70	t
8	hhh	m	88	t
9	iii	w	66	t
10		m	99	t
\.


--
-- Data for Name: person2; Type: TABLE DATA; Schema: public; Owner: root
--

COPY person2 (id, name, sex, age) 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
--