dump.sql
application/sql
Filename: dump.sql
Type: application/sql
Part: 2
--
-- PostgreSQL database dump
--
\restrict bgATzuSyWt7x9tbpJxVmbctYI46kIjE0nIAY8erns1Ohmr0SonQNKGa8axgGVs8
-- Dumped from database version 16.4 (Debian 16.4-3+build4)
-- Dumped by pg_dump version 19devel
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET transaction_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;
SET default_tablespace = '';
SET default_table_access_method = heap;
--
-- Name: t1; Type: TABLE; Schema: public; Owner: hannuk
--
CREATE TABLE public.t1 (
id integer NOT NULL,
data text
);
ALTER TABLE public.t1 OWNER TO hannuk;
--
-- Name: t1_id_seq; Type: SEQUENCE; Schema: public; Owner: hannuk
--
CREATE SEQUENCE public.t1_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER SEQUENCE public.t1_id_seq OWNER TO hannuk;
--
-- Name: t1_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hannuk
--
ALTER SEQUENCE public.t1_id_seq OWNED BY public.t1.id;
--
-- Name: t2; Type: TABLE; Schema: public; Owner: hannuk
--
CREATE TABLE public.t2 (
id integer NOT NULL,
data character(1800)
);
ALTER TABLE public.t2 OWNER TO hannuk;
--
-- Name: t2_id_seq; Type: SEQUENCE; Schema: public; Owner: hannuk
--
CREATE SEQUENCE public.t2_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER SEQUENCE public.t2_id_seq OWNER TO hannuk;
--
-- Name: t2_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hannuk
--
ALTER SEQUENCE public.t2_id_seq OWNED BY public.t2.id;
--
-- Name: t1 id; Type: DEFAULT; Schema: public; Owner: hannuk
--
ALTER TABLE ONLY public.t1 ALTER COLUMN id SET DEFAULT nextval('public.t1_id_seq'::regclass);
--
-- Name: t2 id; Type: DEFAULT; Schema: public; Owner: hannuk
--
ALTER TABLE ONLY public.t2 ALTER COLUMN id SET DEFAULT nextval('public.t2_id_seq'::regclass);
--
-- Data for Name: t1; Type: TABLE DATA; Schema: public; Owner: hannuk
--
COPY public.t1 (id, data) FROM stdin;
1 a
2 b
3 c
\.
--
-- Data for Name: t2; Type: TABLE DATA (pages 0:1); Schema: public; Owner: hannuk
--
COPY public.t2 (id, data) FROM stdin;
1 1
2 2
3 3
4 4
5 5
6 6
7 7
8 8
\.
--
-- Data for Name: t2; Type: TABLE DATA (pages 2:3); Schema: public; Owner: hannuk
--
COPY public.t2 (id, data) FROM stdin;
9 9
10 10
11 11
12 12
13 13
14 14
15 15
16 16
\.
--
-- Data for Name: t2; Type: TABLE DATA (pages 4:5); Schema: public; Owner: hannuk
--
COPY public.t2 (id, data) FROM stdin;
17 17
18 18
19 19
20 20
21 21
22 22
23 23
24 24
\.
--
-- Data for Name: t2; Type: TABLE DATA (pages 6:4294967295); Schema: public; Owner: hannuk
--
COPY public.t2 (id, data) FROM stdin;
25 25
26 26
27 27
28 28
29 29
30 30
\.
--
-- Name: t1_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hannuk
--
SELECT pg_catalog.setval('public.t1_id_seq', 3, true);
--
-- Name: t2_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hannuk
--
SELECT pg_catalog.setval('public.t2_id_seq', 30, true);
--
-- Name: t1 t1_pkey; Type: CONSTRAINT; Schema: public; Owner: hannuk
--
ALTER TABLE ONLY public.t1
ADD CONSTRAINT t1_pkey PRIMARY KEY (id);
--
-- Name: t2 t2_pkey; Type: CONSTRAINT; Schema: public; Owner: hannuk
--
ALTER TABLE ONLY public.t2
ADD CONSTRAINT t2_pkey PRIMARY KEY (id);
--
-- PostgreSQL database dump complete
--
\unrestrict bgATzuSyWt7x9tbpJxVmbctYI46kIjE0nIAY8erns1Ohmr0SonQNKGa8axgGVs8