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
HansH - 18 Sep 2007 14:34 GMT
> 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
Presuming you want to close _client_ psql, try \q
HansH