Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
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 Klaveradrian.klaver@aklaver.com
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 по дате отправления: