|
1 | 1 | .\" This is -*-nroff-*- |
2 | 2 | .\" XXX standard disclaimer belongs here.... |
3 | | -.\" $Header: /cvsroot/pgsql/src/man/Attic/pg_dump.1,v 1.4 1996/12/11 22:58:11 momjian Exp $ |
| 3 | +.\" $Header: /cvsroot/pgsql/src/man/Attic/pg_dump.1,v 1.5 1997/01/17 18:36:32 momjian Exp $ |
4 | 4 | .TH PG_DUMP UNIX 1/20/96 PostgreSQL PostgreSQL |
5 | 5 | .SH NAME |
6 | 6 | pg_dump\(em dumps out a Postgres database into a script file |
@@ -59,6 +59,40 @@ postgreSQL installation to another. After running |
59 | 59 | .IR"pg_dump" |
60 | 60 | , one should examine the output script file for any warnings, especially |
61 | 61 | in light of the limitations listed below. |
| 62 | +.PP |
| 63 | +pg_dump understands the following options: |
| 64 | +.TP |
| 65 | +.BR"-f"" filename" |
| 66 | +Specifies the output file |
| 67 | +.TP |
| 68 | +.BR"-H"" hostname" |
| 69 | +Specifies the server host name |
| 70 | +.TP |
| 71 | +.BR"-p"" port" |
| 72 | +Specifies the server port number |
| 73 | +.TP |
| 74 | +.BR"-v""" |
| 75 | +Specifies verbose mode |
| 76 | +.TP |
| 77 | +.BR"-d""" |
| 78 | +Dump data as proper insert strings |
| 79 | +.TP |
| 80 | +.BR"-D""" |
| 81 | +Dump data as inserts with attribute names |
| 82 | +.TP |
| 83 | +.BR"-S""" |
| 84 | +Dump out only the schema, no data |
| 85 | +.TP |
| 86 | +.BR"-a""" |
| 87 | +Dump out only the data, no schema |
| 88 | +.TP |
| 89 | +.BR"-t"" table" |
| 90 | +Dump for this table only |
| 91 | +.TP |
| 92 | +.BR"-o""" |
| 93 | +Dump object id's (oids) |
| 94 | +.PP |
| 95 | +If dbname is not supplied, then the DATABASE environment variable value is used. |
62 | 96 | .SH "CAVEATS AND LIMITATIONS" |
63 | 97 | .IR pg_dump |
64 | 98 | has a few limitations. |
|