Thread: SQL Query Results

I want to show a certain person the commands I type and the query results,
and I want to save them in a file. I tried \e filename and \E filename and
its not working. Can someone please help me??

In psql you can try \g or \o.  

-----Original Message-----
From:    <No Name> [SMTP:bobmarley4u2c@yahoo.com]
Sent:    Tuesday, January 23, 2001 10:03 PM
To:    pgsql-sql@postgresql.org
Subject:    SQL Query Results

I want to show a certain person the commands I type and the query results,
and I want to save them in a file. I tried \e filename and \E filename and
its not working. Can someone please help me??

On Wed, 24 Jan 2001 18:02,  wrote:
> I want to show a certain person the commands I type and the query results,
> and I want to save them in a file. I tried \e filename and \E filename and
> its not working. Can someone please help me??

I don't know if this is available on your particular machine but you could try
using the 'script' command just before you start psql. When you have done 
that which you wish the "certain person" to see, exit psql in the normal way 
with a '\q', and then exit the script command with an 'exit'

man script

for the full details.

have fun.

-- 
Sincerely etc.,
NAME       Christopher SawtellCELL PHONE 021 257 4451ICQ UIN    45863470EMAIL      csawtell @ xtra . co . nzCNOTES
ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz
-->> Please refrain from using HTML or WORD attachments in e-mails to me <<--