Module7_User_Tools

Question 1

how to run .sql file on psql without first logging in?

Answer 1

psql -f and select file location or

psql -c “command”

Question 2

how to save psql output to file

Answer 2

psql -o FILENAME
or
\o FILENAME

Question 3

how to set variables in PSQL

Answer 3

\set NAME MINA
\echo NAME

\unset stops the variable

Question 4

how to disable autocommit for a session

Answer 4

\set AUTOCOMMIT off

Question 5

how to see current OS directory in psql and change it

Answer 5

! pwd : to see in what directory you are

\cd /new_directory to change directory

Question 6

how to run OS command from psql?

Answer 6

! command