System Catalogs
pg_namespace
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:
Column | Type | Description |
---|---|---|
oid | int | This column represents the Object ID, a unique identifier assigned to each namespace |
nspname | text | This column represents the name of the namespace |
nspowner | int | This column represents the owner of the namespace |
nspacl | text | unused |
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