Postgres Pro
Downloads
Home   >   mailing lists

Thread: psql output result

psql output result

From
Tiffany Thang
Date:
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.
 

Re: psql output result

From
Geoff Winkless
Date:
On 15 March 2018 at 14:57, Tiffany Thang <tiffanythang@gmail.com> wrote:
Is there a way to output the SQLs and DDLs so that I could easily identify what statements were executed?

​
  -a, --echo-all           echo all input from script

Geoff​
 

Re: psql output result

From
Adrian Klaver
Date:
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.klaver@aklaver.com

Re: psql output result

From
Tiffany Thang
Date:
Thanks Geoff and Adrian!

On Thu, Mar 15, 2018 at 11:03 AM, Adrian Klaver <adrian.klaver@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.klaver@aklaver.com