How to back up selected rows using

Поиск
Список
Период
Сортировка
Искать

How to back up selected rows using

От:
Piyush Lenka <lenka.piyush@gmail.com>
Дата:
 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

От:
"Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Дата:
Piyush Lenka  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
FAQ