Schema (namespace) support

[juliano777]

https://www.postgresql.org/docs/current/static/ddl-schemas.html

[turicas]

@juliano777, could you please add more details on this proposed feature?

[juliano777]

SCHEMA is a database object hierarchically just below a database. For example:

Server -> Instance -> Database -> Schema -> {table, index, view, etc}.

In PostgreSQL "public" is the default schema.

CREATE TABLE tb_foo ( field int);

Is equivalent to:

CREATE TABLE public.tb_foo ( field int);

Schemas are organizational structures also known as namespaces. Allows you to create one or more objects with the same name, for example:

CREATE SCHEMA finance; CREATE SCHEMA comercial;

CREATE TABLE finance.tb_foo( . . . );

CREATE TABLE comercial.tb_foo( . . . );

finance.tb_foo and comercial tb_foo have the same name, but different namespaces.