Postgres equivilent of oracle sqlplus "set echo on"

Is there an equivalent in PostgreSQL Oracle SQLPLUS "set echo on" so that I can get the batch input of the expressions reflected in the results?

I have a very large file with input instructions that has several errors on startup. It is difficult for me to find the statement that caused the error, since psql reports only the error - not the statement that generated the error.

+3
source share
2 answers

You need to pass the argument -a(or --echo-all) to psql. The OPTIONS section describes https://www.postgresql.org/docs/current/static/app-psql.html .

+6
source

PostgreSQL , , . , psql, .

0

Source: https://habr.com/ru/post/1794308/


All Articles