psql output result - Mailing list pgsql-general

From Tiffany Thang
Subject psql output result
Date
Msg-id CAB_W-NPNn8FR5GMbgmWmT=Ekf2um00ZZDTmR1KzeXuRCtnNeWg@mail.gmail.com
Whole thread Raw
Responses Re: psql output result  (Geoff Winkless <pgsqladmin@geoff.dj>)
Re: psql output result  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Hi,
I have a SQL script that does some DDLs, inserts and counts.

The command I ran is
psql dbname -c "\i crscript.sql" > output.txt

In output.txt, I got something like
INSERT 0 1
INSERT 0 1
CREATE TABLE
INSERT 0 2
 count
-------
     9
(1 row)


Is there a way to output the SQLs and DDLs so that I could easily identify what statements were executed?

Thanks.
 

pgsql-general by date:

Previous
From: Mike Rylander
Date:
Subject: Change ON UPDATE behavior of fkey
Next
From: Geoff Winkless
Date:
Subject: Re: psql output result