Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Limiting records in pg_dump
- From: John R Pierce <pierce(at)hogranch(dot)com>
- To: "Arnold, Sandra" <ArnoldS(at)osti(dot)gov>, pgsql-general(at)postgresql(dot)org
- Subject: Re: Limiting records in pg_dump
- Date: Fri, 31 Jul 2009 10:59:24 -0700
- Message-id: <4A7330FC.6070900@hogranch.com> <text/plain>
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 ....
- Follow-Ups:
- Re: Limiting records in pg_dump
- From: Arnold, Sandra
- Re: Limiting records in pg_dump
- References:
- Limiting records in pg_dump
- From: Arnold, Sandra
- Limiting records in pg_dump
- Prev by Date: Division by zero
- Next by Date: Re: Limiting records in pg_dump
- Previous by thread: Re: Limiting records in pg_dump
- Next by thread: Re: Limiting records in pg_dump
- Indexes: