--- Chandra Sekhar Surapaneni
> "\o filename";
> "select your_query_goes_here;"
> This should do the trick. Basically \o will start
> writing the results to
> the file.
> "\?" will give you help for such psql commands.
> 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, i think pgadmin3 has a button that saves the
results of a query to a file. that may be worth a
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
In response to
pgsql-novice by date
|Next:||From: Michael Fuhr||Date: 2006-02-17 16:59:08|
|Subject: Re: PostGIS Geometry column in pg8.1.3|
|Previous:||From: Shaler||Date: 2006-02-17 16:06:30|
|Subject: reinstallation of Posstgresql 8.0 program|