Postgre 12 备份数据库

打开pgAdmin 4

在Schemas的pulice库新建address、person表

选中数据库右键

点击Backup

 

https://www.pgadmin.org/docs/pgadmin4/development/backup_dialog.html

翻译如下：

所以Format这里选择plain

打开sql

--

-- PostgreSQL database dump

--



-- Dumped from database version 12.1

-- Dumped by pg_dump version 12.1



-- Started on 2020-09-01 10:37:04



SET statement_timeout = 0;

SET lock_timeout = 0;

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



--

-- TOC entry 9 (class 2615 OID 25108)

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

--



CREATE SCHEMA public;





ALTER SCHEMA public OWNER TO postgres;



--

-- TOC entry 3024 (class 0 OID 0)

-- Dependencies: 9

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

--



COMMENT ON SCHEMA public IS 'standard public schema';





SET default_tablespace = '';



SET default_table_access_method = heap;



--

-- TOC entry 258 (class 1259 OID 25639)

-- Name: address; Type: TABLE; Schema: public; Owner: postgres

--



CREATE TABLE public.address (

    addressid integer NOT NULL,

    personid integer NOT NULL,

    city character varying

);





ALTER TABLE public.address OWNER TO postgres;



--

-- TOC entry 257 (class 1259 OID 25631)

-- Name: person; Type: TABLE; Schema: public; Owner: postgres

--



CREATE TABLE public.person (

    personid integer NOT NULL,

    firsrname character varying,

    lastname character varying

);





ALTER TABLE public.person OWNER TO postgres;



--

-- TOC entry 3018 (class 0 OID 25639)

-- Dependencies: 258

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

--



COPY public.address (addressid, personid, city) FROM stdin;

1     1     北京

\.





--

-- TOC entry 3017 (class 0 OID 25631)

-- Dependencies: 257

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

--



COPY public.person (personid, firsrname, lastname) FROM stdin;

1     小明       张明

\.





--

-- TOC entry 2890 (class 2606 OID 25646)

-- Name: address address_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres

--



ALTER TABLE ONLY public.address

    ADD CONSTRAINT address_pkey PRIMARY KEY (addressid);





--

-- TOC entry 2888 (class 2606 OID 25638)

-- Name: person person_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres

--



ALTER TABLE ONLY public.person

    ADD CONSTRAINT person_pkey PRIMARY KEY (personid);





-- Completed on 2020-09-01 10:37:04



--

-- PostgreSQL database dump complete

--