Hologres allows you to create a table across schemas. This topic describes how to create a schema in a Hologres database and create a table across schemas.
Background information
Compatible with PostgreSQL, Hologres supports the same schema-related operations as PostgreSQL.
After the schema feature is enabled for Hologres, the qualified name format of a table changes from Database name.Table name
to Database name.Schema name.Table name
.
The current version of Hologres allows you to create schemas, rename schemas, and create tables in schemas.
In Hologres, each table belongs to one schema, and a database can contain multiple schemas. Schemas function as logical groups of database objects to ease management. In addition, the use of schemas allows multiple users to use the same database without interfering with each other.
The same table name or data type can be used in different schemas without conflict.
select current_schema(); // Check the current schema.
\d tablename; // Check the schema to which the target table belongs. This statement applies only to terminals.
