The CREATE SCHEMA statement creates a schema in the catalog. The default schema is main.

Examples

Create a schema:

CREATE SCHEMA s1; 

Create a schema if it does not exist yet:

CREATE SCHEMA IF NOT EXISTS s2; 

Create a schema or replace a schema if it exists:

CREATE OR REPLACE SCHEMA s2; 

Create table in the schemas:

CREATE TABLE s1.t (id INTEGER PRIMARY KEY, other_id INTEGER); CREATE TABLE s2.t (id INTEGER PRIMARY KEY, j VARCHAR); 

Compute a join between tables from two schemas:

SELECT * FROM s1.t s1t, s2.t s2t WHERE s1t.other_id = s2t.id; 

Syntax