Skip site navigation (1) Skip section navigation (2)

Re: Queries to Export

From: <operationsengineer1(at)yahoo(dot)com>
To: Chandra Sekhar Surapaneni <chandu(at)positivenetworks(dot)net>, Warren Murray <murray_warren(at)bah(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Queries to Export
Date: 2006-02-17 16:40:04
Message-ID: 20060217164004.16154.qmail@web33312.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
--- Chandra Sekhar Surapaneni
<chandu(at)positivenetworks(dot)net> wrote:

> "\o filename";
> "select your_query_goes_here;"
> "\o"
> 
> This should do the trick. Basically \o will start
> writing the results to
> the file. 
> "\?" will give you help for such psql commands.
> 
> Regards
> Chandra Sekhar Surapaneni
> 
> -----Original Message-----
> From: pgsql-novice-owner(at)postgresql(dot)org
> [mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf
> Of Warren Murray
> Sent: Thursday, February 16, 2006 4:42 PM
> To: pgsql-novice(at)postgresql(dot)org
> Subject: [NOVICE] Queries to Export
> 
> I need to export the results of several union and
> join queries from a
> PostgreSQL database tables into text files.  How is
> that done since the
> results is not in a table?
> 
> Warren

Warren, i think pgadmin3 has a button that saves the
results of a query to a file.  that may be worth a
try, too.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

In response to

pgsql-novice by date

Next:From: Michael FuhrDate: 2006-02-17 16:59:08
Subject: Re: PostGIS Geometry column in pg8.1.3
Previous:From: ShalerDate: 2006-02-17 16:06:30
Subject: reinstallation of Posstgresql 8.0 program

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group