Postgres Pro
Downloads
Home   >   mailing lists

Thread: How to back up selected rows using

How to back up selected rows using

From
Piyush Lenka
Date:
 Hi,

 I have one table in my database. The table contains 10 records(rows) . I want only 5 records(rows) to be backed up.
How can i backup only 5 records from that table using pg_dump or psql or both.
Please Help.

Regards 
Piyush

Re: How to back up selected rows using

From
"Kevin Grittner"
Date:
Piyush Lenka <lenka.piyush@gmail.com> wrote:

> How can i backup only 5 records from that table using pg_dump or psql
or
> both.

In psql:

\copy ( select * from that_table where ... ) to 'filename'

http://www.postgresql.org/docs/9.1/interactive/app-psql.html

Search the page for \copy

-Kevin