Re: Query result to a file

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

Thanks I have found it

Ron St-Pierre wrote:

> 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
>

--
Eduardo Vázquez Rodríguez <evazquez(at)insys-corp(dot)com(dot)mx>
Consultoría Implantación
Tel. 5322 5200

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Jake Stride 2004-08-10 17:32:16 Re: DISTINCT ordering
Previous Message Ron St-Pierre 2004-08-10 16:51:25 Re: Query result to a file