Piyush Lenka <lenka.piyush@xxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin