Re: Limiting records in pg_dump

Arnold, Sandra wrote:
> Is there a way to just dump records equal to a specific value using
> pg_dump?  In Oracle, you can export data and use a WHERE clause and
> only pull a range of data.  We currently use this in Oracle to load
> data sets in our Development database.  As we move to PostgreSQL we
> will be wanting to do the same thing.  If we cannot do it using the
> pg_dump command, I will need to find a work around.

you could create an alternate schema in your DB with VIEW's to your
database table(s) that filter it according to your requirements, then
pg_dump -n schemaname ....