Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Dump and Query
- From: Bruno Wolff III <bruno(at)wolff(dot)to>
- To: Enrico <scotty(at)linuxtime(dot)it>
- Cc: pgsql-admin(at)postgresql(dot)org
- Subject: Re: Dump and Query
- Date: Wed, 27 Dec 2006 14:20:27 -0600
On Wed, Dec 27, 2006 at 14:05:30 +0100, Enrico <scotty(at)linuxtime(dot)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.
- References:
- Dump and Query
- From: Enrico
- Dump and Query
- Prev by Date: Re: psql does not save contents into file at end of command.
- Next by Date: 8.2.0 upgrade issue: postmaster -S
- Previous by thread: Re: Dump and Query
- Next by thread: Importing from excelinto PostgreSQL
- Indexes: