Connecting Tech Pros Worldwide Forums | Help | Site Map

Closing a database

Adam Smith
Guest
 
Posts: n/a
#1: Sep 18 '07
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
Guest
 
Posts: n/a
#2: Sep 18 '07

re: Closing a database


"Adam Smith" <adamsmith@econ.comschreef in bericht
news:tuSdnfaOzqtGJnLbnZ2dnUVZ_remnZ2d@speakeasy.ne t...
Quote:
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



Closed Thread