Change the default schema/database.
schema:gisq
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.
N/A. Access is a single user system.
\connect template1 - scott
ALTER SESSION SET CURRENT_SCHEMA = haggis
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"..
In Oracle this is called a "schema". The new schema is called haggis - it belongs to a user called haggis.
The master database includes system tables, many of these are hidden from normal users.
DataWars: Practice Data Science/Analysis with +100 Real Life Projects Your server today is: digitalocean-sqlzoo