--
-- PostgreSQL database dump
--

SET client_encoding = 'UNICODE';
SET check_function_bodies = false;
SET client_min_messages = warning;

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

COMMENT ON SCHEMA public IS 'Standard public schema';


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = true;

--
-- Name: ptab; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE ptab (
    tadtest_id integer DEFAULT nextval('"ptab_tadtest_id_seq"'::text) NOT NULL,
    tadtest character varying(50),
    tadsecitem character varying(15)
);


ALTER TABLE public.ptab OWNER TO postgres;

--
-- Name: ptab_and_tadtest_and__seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE ptab_and_tadtest_and__seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.ptab_and_tadtest_and__seq OWNER TO postgres;

--
-- Name: ptab_and_tadtest_and__seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('ptab_and_tadtest_and__seq', 1, false);


--
-- Name: ptab_tadtest_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE ptab_tadtest_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.ptab_tadtest_id_seq OWNER TO postgres;

--
-- Name: ptab_tadtest_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('ptab_tadtest_id_seq', 1, false);


--
-- Data for Name: ptab; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY ptab (tadtest_id, tadtest, tadsecitem) FROM stdin;
\.


--
-- Name: ptab_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY ptab
    ADD CONSTRAINT ptab_pkey PRIMARY KEY (tadtest_id);


ALTER INDEX public.ptab_pkey OWNER TO postgres;

--
-- Name: p_tadtest_id_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX p_tadtest_id_idx ON ptab USING btree (tadtest_id);


ALTER INDEX public.p_tadtest_id_idx OWNER TO postgres;

--
-- 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;


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

REVOKE ALL ON TABLE ptab FROM PUBLIC;
REVOKE ALL ON TABLE ptab FROM postgres;
GRANT ALL ON TABLE ptab TO postgres;
GRANT INSERT,SELECT,UPDATE ON TABLE ptab TO pgsqluser;


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

REVOKE ALL ON TABLE ptab_tadtest_id_seq FROM PUBLIC;
REVOKE ALL ON TABLE ptab_tadtest_id_seq FROM postgres;
GRANT ALL ON TABLE ptab_tadtest_id_seq TO postgres;
GRANT SELECT,UPDATE ON TABLE ptab_tadtest_id_seq TO pgsqluser;


--
-- PostgreSQL database dump complete
--