반응형
/********************************************************************************************
-- Title : [9.2] Change other database in PostgreSQL
-- Reference : www.sqlines.com
-- Key word : change database using use command
********************************************************************************************/
No USE dbname Statement in PostgreSQL
In SQL Server or MySQL you can simultaneously work with multiple databases available on the server, and you can change the default database using USE dbname statement.
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.
Simultaneous Work with Multiple Databases:
PostgreSQL | |
Oracle | |
Microsoft SQL Server | |
MySQL |
-- 현재 Database에서 다른 database 연결
ㅇ DBLink 사용
ㅇ PG/Proxy 사용
-- 접속
ㅇ =# \c(onnect) new database
ㅇ 새로운 연결 in pgAdmin III
반응형