On 31/07/2009 18:27, 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.
Not with pg_dump - it's all-or nothing. However, you could use the COPY
command:
http://www.postgresql.org/docs/8.3/static/sql-copy.html
Ray.
------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------
