| From: | nobody <nobody(at)developer(dot)pgadmin(dot)org> |
|---|---|
| To: | pgsql-www(at)postgresql(dot)org |
| Subject: | Comment 1978 added to page backup.html of version 7.4 |
| Date: | 2005-01-09 06:37:19 |
| Message-ID: | 200501090637.j096bJb4010597@developer.pgadmin.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-www |
Author: Tracy Orf <tracyorf(at)charter(dot)net>
----
Section VI.II of the documentation gives information on the pg_dump command. According to the documentation, use pg_dump with the following options:
--table=table
Dump data for table only. It is possible for there to be multiple tables with the same name in different schemas; if that is the case, all matching tables will be dumped. Specify both --schema and --table to select just one table.
Note: In this mode, pg_dump makes no attempt to dump any other database objects that the selected table may depend upon. Therefore, there is no guarantee that the results of a single-table dump can be successfully restored by themselves into a clean database.
----
Manual page: http://wwwmaster.postgresql.org/docs/7.4/interactive/backup.html
Reject: http://wwwmaster.postgresql.org/admin/comments.php?action=reject&id=1978
Edit: http://wwwmaster.postgresql.org/admin/comment-edit.php?id=1978
Delete: http://wwwmaster.postgresql.org/admin/comments.php?action=delete&id=1978
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2005-01-09 13:34:34 | Re: Encoding heck? |
| Previous Message | John Hansen | 2005-01-09 05:37:47 | Re: Search Templates |