Re: logging a psql script - Mailing list pgsql-sql

From Jeff Duffy
Subject Re: logging a psql script
Date
Msg-id Pine.LNX.4.21.0102211705380.4773-100000@cairhien.alanne.com
Whole thread Raw
In response to logging a psql script  (Ken Kline <ken@oldbs.com>)
List pgsql-sql
On Wed, 21 Feb 2001, 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
> CREATE
> CREATE
> CREATE
> 

On UNIX/UNIX-like machines, use the script(1) command (man script for
details).

Jeff

-- 
Errors have occurred.
We won't tell you where or why.
Lazy programmers.    -- Hacking haiku



pgsql-sql by date:

Previous
From: "CM"
Date:
Subject: Re: CREATE TABLE AS and ORDER BY
Next
From: Ian Lance Taylor
Date:
Subject: Re: greetings