renneyt@xxxxxxxxx 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@xxxxxxxxxxxx
