Re: How to back up selected rows using - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: How to back up selected rows using
Date
Msg-id 4F5DC18902000025000460F1@gw.wicourts.gov
Whole thread Raw
In response to How to back up selected rows using  (Piyush Lenka <lenka.piyush@gmail.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Piyush Lenka
Date:
Subject: How to back up selected rows using
Next
From: Rural Hunter
Date:
Subject: Re: triggers are not shared between parent and child tables?