suhailck <suhailck@xxxxxxxxx> wrote: > I need to take backup of my postgresql DB, but not all records > from a few tables. You can exclude particular tables from a database backup using the -T option (which can be included multiple times). You can dump just the schema for particular tables with the -s and -t switches. You can use the \copy command in psql to copy out selected rows using syntax like: \copy (select * from C_order where period=2009 and org <> 'A') to C_order.data You should be able to wire something together from those pieces. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
