summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>1997-01-23 06:01:07 +0000
committerBruce Momjian <bruce@momjian.us>1997-01-23 06:01:07 +0000
commit57148f657fca4136446f20d87c388c55b0ec173f (patch)
tree9693fbc45be0191818f2ae96622f28c37fc8b5c4
parent94515e35224be7c07af2ff71f03dd2efcbe3d2b0 (diff)
Added EXAMPLES section.
-rw-r--r--src/man/pg_dump.112
-rw-r--r--src/man/pg_dumpall.114
2 files changed, 24 insertions, 2 deletions
diff --git a/src/man/pg_dump.1 b/src/man/pg_dump.1
index 52c2f1ded7c..9cefd21ba81 100644
--- a/src/man/pg_dump.1
+++ b/src/man/pg_dump.1
@@ -1,6 +1,6 @@
.\" This is -*-nroff-*-
.\" XXX standard disclaimer belongs here....
-.\" $Header: /cvsroot/pgsql/src/man/Attic/pg_dump.1,v 1.5 1997/01/17 18:36:32 momjian Exp $
+.\" $Header: /cvsroot/pgsql/src/man/Attic/pg_dump.1,v 1.6 1997/01/23 06:01:00 momjian Exp $
.TH PG_DUMP UNIX 1/20/96 PostgreSQL PostgreSQL
.SH NAME
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)
.BR "large objects"
pg_dump does not handle large objects. Large objects are ignored and
must be dealt with manually.
+.SH EXAMPLES
+.nf
+To dump a database:
+
+ pg_dump >db.out
+
+To reload it:
+
+ psql -e database <db.out
+
.SH "SEE ALSO"
copy(l)
diff --git a/src/man/pg_dumpall.1 b/src/man/pg_dumpall.1
index d7eec0a2da5..5ce5b2446c7 100644
--- a/src/man/pg_dumpall.1
+++ b/src/man/pg_dumpall.1
@@ -1,6 +1,6 @@
.\" This is -*-nroff-*-
.\" XXX standard disclaimer belongs here....
-.\" $Header: /cvsroot/pgsql/src/man/Attic/pg_dumpall.1,v 1.1 1997/01/16 15:28:34 momjian Exp $
+.\" $Header: /cvsroot/pgsql/src/man/Attic/pg_dumpall.1,v 1.2 1997/01/23 06:01:07 momjian Exp $
.TH pg_dumpall UNIX 1/20/96 PostgreSQL PostgreSQL
.SH NAME
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
.IR "pg_dumpall"
is a utility for dumping out all Postgres databases into one file.
It also dumps the pg_user table, which is global to all databases.
+pg_dumpall creates each dumped database before loading.
pg_dumpall takes all pg_dump options, but \fB-f\fR and \fBdbname\fR
should not be used.
+.SH EXAMPLES
+.nf
+To dump all databases (you can use pg_dump options):
+
+ pg_dumpall -o >db.out
+
+To reload into a fresh installation (you can use psql options):
+
+ psql -e template1 <db.out
+
+.fi
.SH "SEE ALSO"
pg_dump(1)