​
Overview

The pg_namespace contains information about schema definitions. It mimics the PostgreSQL system catalog pg_namespace.

To learn more about Schema and how it is managed in Oxla, please refer to the Schema documentation.

​
Columns

This table is designed for compatibility with tools that require PostgreSQL system tables, so it mostly has dummy data. Please note that not all columns in pg_namespace are applicable to every type of relation.

The pg_namespace catalog has the following key columns:

ColumnTypeDescription
oidintThis column represents the Object ID, a unique identifier assigned to each namespace
nspnametextThis column represents the name of the namespace
nspownerintThis column represents the owner of the namespace
nspacltextunused

​
Example

​
1. Create a Schema

In this example, we create “sales” and “hr” schemas using the query below:

CREATE SCHEMA sales;
CREATE SCHEMA hr;

The successful result would look like this:

COMPLETE
COMPLETE

​
2. View Schema Definitions

We then use a SELECT statement on the pg_namespace catalog to show the schema definitions.

SELECT nspname AS schema_name, oid AS schema_oid
FROM pg_namespace;

The result shows the list of schemas and its ID, as shown below:

 schema_name | schema_oid 
-------------+------------
 public      |          0
 sales       |          3
 hr          |          4
pg_indexpg_attrdef