--
-- PostgreSQL database dump
--

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

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

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

CREATE TABLE t (
    id integer DEFAULT nextval(('"public"."seq"'::text)::regclass) NOT NULL,
    ids integer[]
);


ALTER TABLE public.t OWNER TO postgres;

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

CREATE TABLE ta (
    id integer DEFAULT nextval(('"public"."seq"'::text)::regclass) NOT NULL,
    "name" text NOT NULL
);


ALTER TABLE public.ta OWNER TO postgres;

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

CREATE TABLE tb (
    id integer DEFAULT nextval(('"public"."seq"'::text)::regclass) NOT NULL,
    "name" text NOT NULL
);


ALTER TABLE public.tb OWNER TO postgres;


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

INSERT INTO t (id, ids) VALUES (1, '{1,3,8,9,10,12}');
INSERT INTO t (id, ids) VALUES (2, '{2,6,7,11,12}');
INSERT INTO t (id, ids) VALUES (3, '{3,5,6,9,11,14}');
INSERT INTO t (id, ids) VALUES (4, '{4,5,7,8,9,13}');
INSERT INTO t (id, ids) VALUES (5, '{5,6,8,10,12}');


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

INSERT INTO ta (id, "name") VALUES (6, 'ant_a');
INSERT INTO ta (id, "name") VALUES (7, 'ant_b');
INSERT INTO ta (id, "name") VALUES (8, 'ant_c');


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

INSERT INTO tb (id, "name") VALUES (9, 'bee_a');
INSERT INTO tb (id, "name") VALUES (10, 'bee_b');
INSERT INTO tb (id, "name") VALUES (11, 'bee_c');


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

ALTER TABLE ONLY t
    ADD CONSTRAINT pk_t PRIMARY KEY (id);


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

ALTER TABLE ONLY ta
    ADD CONSTRAINT pk_ta PRIMARY KEY (id);


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

ALTER TABLE ONLY tb
    ADD CONSTRAINT pk_tb PRIMARY KEY (id);


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



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


