Connecting Tech Pros Worldwide Help | Site Map

Closing a database

  #1  
Old September 18th, 2007, 12:55 PM
Adam Smith
Guest
 
Posts: n/a
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
  #2  
Old September 18th, 2007, 02:45 PM
HansH
Guest
 
Posts: n/a

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Closing database in VB .Net Vegar Hansen answers 1 November 20th, 2005 05:44 AM
Closing database connection. Brent answers 2 November 18th, 2005 08:23 AM
Closing database connection. Brent answers 4 November 18th, 2005 07:49 AM
Closing database connection. Brent answers 0 November 18th, 2005 07:47 AM
closing database connections dustin lee answers 4 July 18th, 2005 08:52 AM