Re: How to back up selected rows using

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