SQLzoo.net

Change the default schema/database.

Postgres
In many engines several independant databases may exist. Often each user has his or her own database. This allows different users to use the same names for tables.


Specific to Postgres
The \ commands are not part of SQL, they may be entered in the psql interface to postgres. The given command connects to database "template1" as user "scott".

Related links:

  • USERS