This is one stop global knowledge base where you can learn about all the products, solutions and support features.
schemata
The view
schemata
contains all schemas in the current database that the current user has access to (by way of being the owner or having some privilege).
Table 37.44.
schemata
Columns
|
Column Type Description |
|---|
|
Name of the database that the schema is contained in (always the current database) |
|
Name of the schema |
|
Name of the owner of the schema |
|
Applies to a feature not available in PostgreSQL |
|
Applies to a feature not available in PostgreSQL |
|
Applies to a feature not available in PostgreSQL |
|
Applies to a feature not available in PostgreSQL |
schemata
The view
schemata
contains all schemas in the current database that the current user has access to (by way of being the owner or having some privilege).
Table 37.44.
schemata
Columns
|
Column Type Description |
|---|
|
Name of the database that the schema is contained in (always the current database) |
|
Name of the schema |
|
Name of the owner of the schema |
|
Applies to a feature not available in PostgreSQL |
|
Applies to a feature not available in PostgreSQL |
|
Applies to a feature not available in PostgreSQL |
|
Applies to a feature not available in PostgreSQL |
SPI_gettypeid — return the data type OID of the specified column
Oid SPI_gettypeid(TupleDescrowdesc, intcolnumber)
SPI_gettypeid
returns the
OID
of the data type of the specified column.
TupleDesc
rowdesc
input row description
int
colnumber
column number (count starts at 1)
The
OID
of the data type of the specified column or
InvalidOid
on error. On error,
SPI_result
is set to
SPI_ERROR_NOATTRIBUTE
.
SPI_gettypeid — return the data type OID of the specified column
Oid SPI_gettypeid(TupleDescrowdesc, intcolnumber)
SPI_gettypeid
returns the
OID
of the data type of the specified column.
TupleDesc
rowdesc
input row description
int
colnumber
column number (count starts at 1)
The
OID
of the data type of the specified column or
InvalidOid
on error. On error,
SPI_result
is set to
SPI_ERROR_NOATTRIBUTE
.
routine_column_usage
The view
routine_column_usage
is meant to identify all columns that are used by a function or procedure. This information is currently not tracked by
PostgreSQL
.
Table 37.38.
routine_column_usage
Columns
|
Column Type Description |
|---|
|
Name of the database containing the function (always the current database) |
|
Name of the schema containing the function |
|
The “ specific name ” of the function. See Section 37.45 for more information. |
|
Name of the database containing the function (always the current database) |
|
Name of the schema containing the function |
|
Name of the function (might be duplicated in case of overloading) |
|
Name of the database that contains the table that is used by the function (always the current database) |
|
Name of the schema that contains the table that is used by the function |
|
Name of the table that is used by the function |
|
Name of the column that is used by the function |
routine_column_usage
The view
routine_column_usage
is meant to identify all columns that are used by a function or procedure. This information is currently not tracked by
PostgreSQL
.
Table 37.38.
routine_column_usage
Columns
|
Column Type Description |
|---|
|
Name of the database containing the function (always the current database) |
|
Name of the schema containing the function |
|
The “ specific name ” of the function. See Section 37.45 for more information. |
|
Name of the database containing the function (always the current database) |
|
Name of the schema containing the function |
|
Name of the function (might be duplicated in case of overloading) |
|
Name of the database that contains the table that is used by the function (always the current database) |
|
Name of the schema that contains the table that is used by the function |
|
Name of the table that is used by the function |
|
Name of the column that is used by the function |