how to "pg_dump", based in select command

From: "Jeferson Kasper" <jefersonkasper(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: how to "pg_dump", based in select command
Date: 2007-07-03 17:09:16
Message-ID: d1e5962b0707031009y5283ba97yade2e7dee04a4d7d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Zdenek Kotala 2007-07-03 17:13:29 Re: Proposal: In-Place upgrade concept
Previous Message Tom Lane 2007-07-03 16:43:58 Re: pgstat_drop_relation bugfix