In MySQL I used use database_name;
What's the PostgreSQL equivalent?
+1: This is JUST a psql command, in Postgres itself, there is no way to "switch". In fact, psql isn't "switching" in the MySQL context, just closing one connection and opening another.
rfusca
2010-10-17 16:50:29
A:
You can connect to a different database with \c <database> or \connect <database>:
meagar
2010-10-16 17:14:36