Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
1.2k views
in Technique[技术] by (71.8m points)

postgresql - How to switch databases in postgres?

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.

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

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.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...