Thanks Geoff and Adrian! On Thu, Mar 15, 2018 at 11:03 AM, Adrian Klaver <adrian.kla...@aklaver.com> wrote:
> On 03/15/2018 07:57 AM, Tiffany Thang wrote: > >> 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? >> > > aklaver@tito:~> psql -d test -U aklaver -a -f sql_test.sql > \pset null 'NULL' > Null display is "NULL". > CREATE TABLE tbl_test(fld_1 int, fld_2 varchar); > CREATE TABLE > INSERT INTO tbl_test VALUES (1, 'dog'), (2, 'cat'); > INSERT 0 2 > DROP TABLE tbl_test; > DROP TABLE > > >> Thanks. >> >> > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
