Обсуждение: How to back up selected rows using

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

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

Re: How to back up selected rows using

От
"Kevin Grittner"
Дата:
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