On 7/3/07, Jeferson Kasper <[EMAIL PROTECTED]> 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.


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to