Re: PG_DUMP

[Jeff Boes <jeff(at)endpoint(dot)com>]

renneyt(at)yahoo(dot)com wrote:
> Is there a way to do a selective pg_dump of a table using a select
> where clause? As in ... dump all records where now-col_date < 2 or
> col_date='01-may-2006' etc.. ?
You can transfer the subset of data to another table, e.g.,

create table my_dump as select * from table_foo where ...

and then dump that table. Note that you can't do this to a view (pg_dump
will dump the view definition, but not the data).

-- 
Jeffery Boes  <><
jeff(at)endpoint(dot)com