toc.dat0000600 0004000 0002000 00000005226 14263056652 0014455 0ustar00postgrespostgres0000000 0000000 PGDMP  zrevocatio_test14.314.3 00ENCODINGENCODING#SET client_encoding = 'SQL_ASCII'; false 00 STDSTRINGS STDSTRINGS(SET standard_conforming_strings = 'on'; false 00 SEARCHPATH SEARCHPATH8SELECT pg_catalog.set_config('search_path', '', false); false 126240962revocatio_testDATABASE^CREATE DATABASE revocatio_test WITH TEMPLATE = template0 ENCODING = 'SQL_ASCII' LOCALE = 'C'; DROP DATABASE revocatio_test; michaelfalse125940973revocatio_testTABLEOCREATE TABLE public.revocatio_test ( id integer NOT NULL, name text ); "DROP TABLE public.revocatio_test; publicheapmichaelfalse125940972revocatio_test_id_seqSEQUENCECREATE SEQUENCE public.revocatio_test_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ,DROP SEQUENCE public.revocatio_test_id_seq; publicmichaelfalse210 00revocatio_test_id_seqSEQUENCE OWNED BYOALTER SEQUENCE public.revocatio_test_id_seq OWNED BY public.revocatio_test.id; publicmichaelfalse209m 260440976revocatio_test idDEFAULTvALTER TABLE ONLY public.revocatio_test ALTER COLUMN id SET DEFAULT nextval('public.revocatio_test_id_seq'::regclass); @ALTER TABLE public.revocatio_test ALTER COLUMN id DROP DEFAULT; publicmichaelfalse210209210 040973revocatio_test TABLE DATA2COPY public.revocatio_test (id, name) FROM stdin; publicmichaelfalse2103324.dat 00revocatio_test_id_seq SEQUENCE SETCSELECT pg_catalog.setval('public.revocatio_test_id_seq', 4, true); publicmichaelfalse209o 260640980"revocatio_test revocatio_test_pkey CONSTRAINT`ALTER TABLE ONLY public.revocatio_test ADD CONSTRAINT revocatio_test_pkey PRIMARY KEY (id); LALTER TABLE ONLY public.revocatio_test DROP CONSTRAINT revocatio_test_pkey; publicmichaelfalse2103324.dat0000600 0004000 0002000 00000000035 14263056652 0014254 0ustar00postgrespostgres0000000 0000000 1 abc 2 def 3 ghi 4 jkl \. restore.sql0000600 0004000 0002000 00000005340 14263056652 0015377 0ustar00postgrespostgres0000000 0000000 -- -- NOTE: -- -- File paths need to be edited. Search for $$PATH$$ and -- replace it with the path to the directory containing -- the extracted data files. -- -- -- PostgreSQL database dump -- -- Dumped from database version 14.3 -- Dumped by pg_dump version 14.3 SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET client_encoding = 'SQL_ASCII'; 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; DROP DATABASE revocatio_test; -- -- Name: revocatio_test; Type: DATABASE; Schema: -; Owner: michael -- CREATE DATABASE revocatio_test WITH TEMPLATE = template0 ENCODING = 'SQL_ASCII' LOCALE = 'C'; ALTER DATABASE revocatio_test OWNER TO michael; \connect revocatio_test SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET client_encoding = 'SQL_ASCII'; 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: revocatio_test; Type: TABLE; Schema: public; Owner: michael -- CREATE TABLE public.revocatio_test ( id integer NOT NULL, name text ); ALTER TABLE public.revocatio_test OWNER TO michael; -- -- Name: revocatio_test_id_seq; Type: SEQUENCE; Schema: public; Owner: michael -- CREATE SEQUENCE public.revocatio_test_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.revocatio_test_id_seq OWNER TO michael; -- -- Name: revocatio_test_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: michael -- ALTER SEQUENCE public.revocatio_test_id_seq OWNED BY public.revocatio_test.id; -- -- Name: revocatio_test id; Type: DEFAULT; Schema: public; Owner: michael -- ALTER TABLE ONLY public.revocatio_test ALTER COLUMN id SET DEFAULT nextval('public.revocatio_test_id_seq'::regclass); -- -- Data for Name: revocatio_test; Type: TABLE DATA; Schema: public; Owner: michael -- COPY public.revocatio_test (id, name) FROM stdin; \. COPY public.revocatio_test (id, name) FROM '$$PATH$$/3324.dat'; -- -- Name: revocatio_test_id_seq; Type: SEQUENCE SET; Schema: public; Owner: michael -- SELECT pg_catalog.setval('public.revocatio_test_id_seq', 4, true); -- -- Name: revocatio_test revocatio_test_pkey; Type: CONSTRAINT; Schema: public; Owner: michael -- ALTER TABLE ONLY public.revocatio_test ADD CONSTRAINT revocatio_test_pkey PRIMARY KEY (id); -- -- PostgreSQL database dump complete --