Re: [SQL] logging a psql script

2001-02-22 Thread Christopher Sawtell
On Thu, 22 Feb 2001 10:51, Ken Kline wrote: > Hello, >I would like my psql script to log everything that it does. Issue the command "script" before you start psql. It will record everything you see on you screen provided it is not piped into another program such as "more" or "less". man sc

Re: [SQL] logging a psql script

2001-02-21 Thread Oliver Elphick
Ken Kline wrote: >Hello, > I would like my psql script to log everything that it does. psql -e -- Oliver Elphick[EMAIL PROTECTED] Isle of Wight http://www.lfix.co.uk/oliver PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 3

Re: [SQL] logging a psql script

2001-02-21 Thread Frank Joerdens
On Wed, Feb 21, 2001 at 04:51:00PM -0500, Ken Kline wrote: > Hello, >I would like my psql script to log everything that it does. > I set the following > > \set ECHO all > \o foo.txt > \qecho > > some sql, some ddl, etc... > > \o > > > But foo.txt only contains > > DROP > DROP > DROP > CR

[SQL] logging a psql script

2001-02-21 Thread Ken Kline
Hello, I would like my psql script to log everything that it does. I set the following \set ECHO all \o foo.txt \qecho some sql, some ddl, etc... \o But foo.txt only contains DROP DROP DROP CREATE CREATE CREATE I want it to contain everything that I see on the screen, what am I missing?