Re: Limiting records in pg_dump

[Raymond O'Donnell <rod(at)iol(dot)ie>]

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(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------