Re: Dump and Query - Mailing list pgsql-admin

From Bruno Wolff III
Subject Re: Dump and Query
Date
Msg-id 20061227202027.GA10295@wolff.to
Whole thread Raw
In response to Dump and Query  (Enrico <scotty@linuxtime.it>)
List pgsql-admin
On Wed, Dec 27, 2006 at 14:05:30 +0100,
  Enrico <scotty@linuxtime.it> wrote:
> Is there any way to make a dump from a query?
>
> For example if my query is:
>
> select field1,field2 from table
>
> Does it exist a shell command like pg_dump --QUERY myquery -f myfile?

In 8.2 you can use a query with the COPY command. Depending on what
you are really doing, that might be a solution for you.

pgsql-admin by date:

Previous
From: "Rajesh Kumar Mallah"
Date:
Subject: Re: psql does not save contents into file at end of command.
Next
From: L Bayuk
Date:
Subject: 8.2.0 upgrade issue: postmaster -S