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