Thanks Geoff and Adrian!
On Thu, Mar 15, 2018 at 11:03 AM, Adrian Klaver
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,
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
On 15 March 2018 at 14:57, Tiffany Thang 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
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
