Re: Query result to a file

From: Ron St-Pierre <rstpierre(at)syscor(dot)com>
To: Eduardo Vázquez Rodríguez <evazquez(at)insys-corp(dot)com(dot)mx>, pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Query result to a file
Date: 2004-08-10 16:51:25
Message-ID: 4118FD0D.5050303@syscor.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Eduardo Vázquez Rodríguez wrote:

> Hi everybody out there using Postgres.
>
> I am using PgAdminIII & I would like that my query results that
> appears on the console might be redirected to a file or to a temporary
> table.
>
>
> Someone suggested in this list that I redirect the output of the query
> using the "query" > file, but my intention is that the new file must
> be on the client side.
>
> My goal is to create a graphic from the query results and procesing
> the data from the text file.
>
>
> Any suggestions are welcome. :-)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
>
Doesn't pgAdminIII have an option to output the results to the screen,
to a text file, to html, or to an excel spreadsheet? In pgAdminII it's a
dropdown box at the bottom of the SQL input window.

Ron

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Eduardo Vázquez Rodríguez 2004-08-10 16:59:47 Re: Query result to a file
Previous Message Michal Lijowski 2004-08-10 16:31:50 Using pgaccess and xpg