Skip to content

Commit 57148f6

Browse files
committed
Added EXAMPLES section.
1 parent 94515e3 commit 57148f6

File tree

2 files changed

+24
-2
lines changed

2 files changed

+24
-2
lines changed

src/man/pg_dump.1

Lines changed: 11 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,6 @@
11
.\" This is -*-nroff-*-
22
.\" XXX standard disclaimer belongs here....
3-
.\" $Header: /cvsroot/pgsql/src/man/Attic/pg_dump.1,v 1.5 1997/01/17 18:36:32 momjian Exp $
3+
.\" $Header: /cvsroot/pgsql/src/man/Attic/pg_dump.1,v 1.6 1997/01/23 06:01:00 momjian Exp $
44
.TH PG_DUMP UNIX 1/20/96 PostgreSQL PostgreSQL
55
.SH NAME
66
pg_dump \(em dumps out a Postgres database into a script file
@@ -112,5 +112,15 @@ the same as above. Partial index predicates are stored as plans)
112112
.BR "large objects"
113113
pg_dump does not handle large objects. Large objects are ignored and
114114
must be dealt with manually.
115+
.SH EXAMPLES
116+
.nf
117+
To dump a database:
118+
119+
pg_dump >db.out
120+
121+
To reload it:
122+
123+
psql -e database <db.out
124+
115125
.SH "SEE ALSO"
116126
copy(l)

src/man/pg_dumpall.1

Lines changed: 13 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,6 @@
11
.\" This is -*-nroff-*-
22
.\" XXX standard disclaimer belongs here....
3-
.\" $Header: /cvsroot/pgsql/src/man/Attic/pg_dumpall.1,v 1.1 1997/01/16 15:28:34 momjian Exp $
3+
.\" $Header: /cvsroot/pgsql/src/man/Attic/pg_dumpall.1,v 1.2 1997/01/23 06:01:07 momjian Exp $
44
.TH pg_dumpall UNIX 1/20/96 PostgreSQL PostgreSQL
55
.SH NAME
66
pg_dumpall \(em dumps out all Postgres databases into a script file
@@ -11,7 +11,19 @@ pg_dumpall \(em dumps out all Postgres databases into a script file
1111
.IR "pg_dumpall"
1212
is a utility for dumping out all Postgres databases into one file.
1313
It also dumps the pg_user table, which is global to all databases.
14+
pg_dumpall creates each dumped database before loading.
1415
pg_dumpall takes all pg_dump options, but \fB-f\fR and \fBdbname\fR
1516
should not be used.
17+
.SH EXAMPLES
18+
.nf
19+
To dump all databases (you can use pg_dump options):
20+
21+
pg_dumpall -o >db.out
22+
23+
To reload into a fresh installation (you can use psql options):
24+
25+
psql -e template1 <db.out
26+
27+
.fi
1628
.SH "SEE ALSO"
1729
pg_dump(1)

0 commit comments

Comments
 (0)