Hello,
Been away from PostgreSQL for a while and probably needs retraining in
the basics.

How do I close a database? Can't even find it in the Manual

Case:
testdb=#
testdb=# EXIT;
ERROR: syntax error at or near "EXIT" at character 1
LINE 1: EXIT;
^
testdb=#
testdb=# QUIT;
ERROR: syntax error at or near "QUIT" at character 1
LINE 1: QUIT;
^
testdb=#
testdb=# END;
WARNING: there is no transaction in progress
<p>COMMIT</p>
testdb=#

quit works in MySQL

Stuck in testdb

Adam Smith <adamsmith (AT) econ (DOT) com> writes:

You don't "close a database"; you close your connection to
it. Quitting the client is probably the simplest way.

For psql, the '\q' command is "quit". It also quits when it receives
the end-of-text signal (Ctrl+D on Unix).

Use '\?' to see the commands you can use to interact with psql.

--
\ "Never use a long word when there's a commensurate diminutive |
`\ available." -- Stan Kelly-Bootle |
_o__) |
Ben Finney