Re: conditional backup

suhailck <suhailck@gmail.com> 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