pgarchive 0.4.1

Read PostgreSQL custom format archives
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70

PGDMP%4{pizza14.6 (Homebrew)14.6 (Homebrew)
00ENCODINGENCODINGSET client_encoding = 'UTF8';
false00
STDSTRINGS
STDSTRINGS(SET standard_conforming_strings = 'on';
false00
SEARCHPATH
SEARCHPATH8SELECT pg_catalog.set_config('search_path', '', false);
false1262513003pizzaDATABASEPCREATE DATABASE pizza WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE = 'C';
DROP DATABASE pizza;
wichert.akkermanfalse�1259513004pizzaTABLEUCREATE TABLE public.pizza (
    pizza_id integer NOT NULL,
    name text NOT NULL
);
DROP TABLE public.pizza;
publicheapwichert.akkermanfalse�1259513009pizza_pizza_id_seqSEQUENCE�ALTER TABLE public.pizza ALTER COLUMN pizza_id ADD GENERATED ALWAYS AS IDENTITY (
    SEQUENCE NAME public.pizza_pizza_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);
publicwichert.akkermanfalse209�1259513010
pizza_toppingTABLEfCREATE TABLE public.pizza_topping (
    pizza_id integer NOT NULL,
    topping_id integer NOT NULL
);
!DROP TABLE public.pizza_topping;
publicheapwichert.akkermanfalse�1259513013toppingTABLEYCREATE TABLE public.topping (
    topping_id integer NOT NULL,
    name text NOT NULL
);
DROP TABLE public.topping;
publicheapwichert.akkermanfalse�1259513018topping_topping_id_seqSEQUENCE�ALTER TABLE public.topping ALTER COLUMN topping_id ADD GENERATED ALWAYS AS IDENTITY (
    SEQUENCE NAME public.topping_topping_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);
publicwichert.akkermanfalse2120513004pizza
TABLE DATA/COPY public.pizza (pizza_id, name) FROM stdin;
publicwichert.akkermanfalse209�0513010
pizza_topping
TABLE DATA=COPY public.pizza_topping (pizza_id, topping_id) FROM stdin;
publicwichert.akkermanfalse211!	0513013topping
TABLE DATA3COPY public.topping (topping_id, name) FROM stdin;
publicwichert.akkermanfalse212a00pizza_pizza_id_seqSEQUENCE SET@SELECT pg_catalog.setval('public.pizza_pizza_id_seq', 5, true);
publicwichert.akkermanfalse21000topping_topping_id_seqSEQUENCE SETDSELECT pg_catalog.setval('public.topping_topping_id_seq', 6, true);
publicwichert.akkermanfalse213t
2606513020pizza pizza_pkey
CONSTRAINTTALTER TABLE ONLY public.pizza
    ADD CONSTRAINT pizza_pkey PRIMARY KEY (pizza_id);
:ALTER TABLE ONLY public.pizza DROP CONSTRAINT pizza_pkey;
publicwichert.akkermanfalse209v
2606513022 pizza_topping pizza_topping_pkey
CONSTRAINTpALTER TABLE ONLY public.pizza_topping
    ADD CONSTRAINT pizza_topping_pkey PRIMARY KEY (pizza_id, topping_id);
JALTER TABLE ONLY public.pizza_topping DROP CONSTRAINT pizza_topping_pkey;
publicwichert.akkermanfalse211211x
2606513024topping topping_pkey
CONSTRAINTZALTER TABLE ONLY public.topping
    ADD CONSTRAINT topping_pkey PRIMARY KEY (topping_id);
>ALTER TABLE ONLY public.topping DROP CONSTRAINT topping_pkey;
publicwichert.akkermanfalse212r
1259513035
pizza_nameINDEX<CREATE INDEX pizza_name ON public.pizza USING btree (name);
DROP INDEX public.pizza_name;
publicwichert.akkermanfalse209y
2606513025)pizza_topping pizza_topping_pizza_id_fkey
FK CONSTRAINT�ALTER TABLE ONLY public.pizza_topping
    ADD CONSTRAINT pizza_topping_pizza_id_fkey FOREIGN KEY (pizza_id) REFERENCES public.pizza(pizza_id) ON UPDATE CASCADE ON DELETE CASCADE;
SALTER TABLE ONLY public.pizza_topping DROP CONSTRAINT pizza_topping_pizza_id_fkey;
publicwichert.akkermanfalse2112093444z
2606513030+pizza_topping pizza_topping_topping_id_fkey
FK CONSTRAINT�ALTER TABLE ONLY public.pizza_topping
    ADD CONSTRAINT pizza_topping_topping_id_fkey FOREIGN KEY (topping_id) REFERENCES public.topping(topping_id) ON UPDATE CASCADE ON DELETE RESTRICT;
UALTER TABLE ONLY public.pizza_topping DROP CONSTRAINT pizza_topping_topping_id_fkey;
publicwichert.akkermanfalse2122113448Ex�3��HUp�I,.�L�2�t��Qp�HM-N�2�KMO�L�2�q-K-�,���K�2�$�q��qqq�V>0x�3�4�2bCN#.# 6b0�H�M�4��̀�W��_�	Dx�3�,��KM,(�I�2�L�HM-N�2�L�)MU��L83s�L���E�U�\f����E���\1z\\\ˁ^