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