[ADMIN] How to back up selected rows using

[Piyush Lenka]

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

[Kevin Grittner]

Post by Piyush Lenka
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