May 2018
Intermediate to advanced
576 pages
30h 25m
English
Let's start with a simple script, with a command we know will fail:
$ $EDITOR test.sqlmistake1;mistake2;mistake3;
Execute the following script using psql to see what the results look like:
$ psql -f test.sqlpsql:test.sql:1: ERROR: syntax error at or near "mistake1"LINE 1: mistake1; ^psql:test.sql:2: ERROR: syntax error at or near "mistake2"LINE 1: mistake2; ^psql:test.sql:3: ERROR: syntax error at or near "mistake3"LINE 1: mistake3; ^