dbTalk Databases Forums  

Closing a database

comp.databases.postgresql.general comp.databases.postgresql.general


Discuss Closing a database in the comp.databases.postgresql.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Adam Smith
 
Posts: n/a

Default Closing a database - 09-18-2007 , 07:48 AM






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

Reply With Quote
  #2  
Old   
HansH
 
Posts: n/a

Default Re: Closing a database - 09-18-2007 , 09:34 AM






"Adam Smith" <adamsmith (AT) econ (DOT) com> schreef in bericht
news:tuSdnfaOzqtGJnLbnZ2dnUVZ_remnZ2d (AT) speakeasy (DOT) net...
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





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.