Re: logging a psql script

From: Jeff Duffy <jduffy(at)greatbridge(dot)com>
To: Ken Kline <ken(at)oldbs(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: logging a psql script
Date: 2001-02-21 22:06:21
Message-ID: Pine.LNX.4.21.0102211705380.4773-100000@cairhien.alanne.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Frank Joerdens 2001-02-21 22:36:45 Re: logging a psql script
Previous Message Tom Lane 2001-02-21 21:55:33 Re: now() with microsecond granulity needed