pg_dump使用

pg_dump -h 127.0.0.1 -U jiang postgres > databasename.bak
psql -h localhost -U jiang -d postgres < databasename.bak

databasename.bak底部内容
COPY public.t1 (id, c1) FROM stdin;
1 3
1 3
1 3
1 3
1 3
1 2
\.

--
-- Data for Name: t2; Type: TABLE DATA; Schema: public; Owner: jiang
--

COPY public.t2 (id, c1) FROM stdin;
1 b
\.

--
-- PostgreSQL database dump complete
--