Re: conditional backup

suhailck  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