Change the default schema/database.

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

Use Master

USE scott

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.

Users

Create a new user

Read tables from another schema/database

Change the default schema/database.

Find another process and kill it.

Set a timeout.

Change my own password

Who am I?