The catalog pg_transform stores information about transforms, which are a mechanism to adapt data types to procedural languages. See
The catalog pg_foreign_table contains auxiliary information about foreign tables. A foreign table is primarily represented by a
The view pg_tables provides access to useful information about each table in the database.
The catalog pg_largeobject holds the data making up "large objects". A large object is identified by an OID assigned
The catalog pg_shseclabel stores security labels on shared database objects. Security labels can be manipulated with the
Table 50-1 lists the system catalogs. More detailed documentation of each catalog follows below. Most system catalogs are copied from the template
The catalog pg_operator stores information about operators. See CREATE
The catalog pg_range stores information about range types. This is in addition to the types' entries in
The catalog pg_auth_members shows the membership relations between roles. Any non-circular set of relationships is allowed.
The catalog pg_namespace stores namespaces. A namespace is the structure underlying SQL schemas: each namespace can have a separate collection
Page 1 of 9