suhailck <suhailck(at)gmail(dot)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