Re: [GENERAL] Limiting records in pg_dump

2009-07-31 Thread Adrian Klaver
- "Sandra Arnold" wrote: > Thanks for that suggestion. Since I have a schema on the database, I > could create the view on my schema or even a table with the same name > with just the records that I want to copy to the other database. I > had thought about the table but not necessary th

Re: [GENERAL] Limiting records in pg_dump

2009-07-31 Thread Arnold, Sandra
-general@postgresql.org Subject: Re: [GENERAL] 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 us

Re: [GENERAL] Limiting records in pg_dump

2009-07-31 Thread John R Pierce
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

Re: [GENERAL] Limiting records in pg_dump

2009-07-31 Thread Raymond O'Donnell
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 w