Thread: how to "pg_dump", based in select command

On 7/3/07, Jeferson Kasper <jefersonkasper@gmail.com> wrote:
> Hello folks.
> I want to know how to dump some parts of a database?
> I need to extract the records in a "select * from table" and the pg_dump or
> other tool will create a file with the records found in this "select
> command", and after this, i will restore this file in another database with
> the same structure.
> Any idea?
> Thanks people.
>
> Jeferson Kasper
>

In 8.2 you can use the COPY command with a query, as in COPY (SELECT
...) TO 'filename'

In earlier versions, one alternative is to create a table filled with
the results of your query and pg_dump it. Alternatively you might also
pipe the query into psql and pipe the output to a file, use psql's \o
option, etc.

-Josh