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 ....
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
