Menu
In SQL Server, I use:
use database_name
Go
Select * from table_name
In postgreSQL, I still use:
\connect database_name
Select * from table_name
========================
then error:
ERROR: syntax error at or near "\"
LINE 1: \connect database_name
^
********** Error **********
ERROR: syntax error at or near "\"
SQL state: 42601
Character: 1.
Why? Can do help me? Thanks.
922
When you need to change between databases, you'll use the “connect” command, which is conveniently shortened to \c, followed by the database name.
In PostgreSQL you can work with a single database only, and there is no a USE dbname statement to change the database, you have to close the current connection and then connect to another database.
Select Database using psql To select a database or make a connection to the database, run the select/connect command as shown below. where databasename is the name of your database. A connection has been made to the database mydb and you can see the prompt changed to mydb-# .
Technically PostgreSQL can't switch databases. You must disconnect and reconnect to the new DB.
The psql command-line client will do this for you with the \connect command, shortcut \c. But these are not commands processed by the PostgreSQL server, they're client commands. Different clients won't understand or support them.
At a guess you're using PgAdmin-III, in which case use the pulldown menu in the query tool to switch databases.
Some day I'd like to extract psql's backslash-commands code into a library that things like PgAdmin could link to and use too.
65
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
