parameters

The parameters view provides information about parameters of functions and procedures in the current database.

Column name	Data type	Description
specific_catalog	sql_identifier	The name of the current database containing the function.
specific_schema	sql_identifier	The name of the schema containing the function.
specific_name	sql_identifier	The “specific name” of the function.
ordinal_position	cardinal_number	The ordinal position of the parameter in the function’s argument list. The count starts at 1.
parameter_mode	character_data	The parameter mode. The possible values are: IN OUT INOUT
is_result	yes_or_no	Applies to a feature that is not available in PostgreSQL.
as_locator	yes_or_no	Applies to a feature that is not available in PostgreSQL.
parameter_name	sql_identifier	The name of the parameter. NULL – No name is defined.
data_type	character_data	The parameter’s data type. For built-in types, this is a type name. For array types, the value is ARRAY. For user-defined types, the value is USER-DEFINED, and the actual type is identified by udt_catalog, udt_schema, and udt_name.
character_maximum_length	cardinal_number	The maximum length for function parameters. Always NULL in PostgreSQL for parameters.
character_octet_length	cardinal_number	The maximum possible length, in octets, for function parameters. Always NULL in PostgreSQL for parameters.
character_set_catalog	sql_identifier	Applies to a feature not available in PostgreSQL.
character_set_schema	sql_identifier	Applies to a feature not available in PostgreSQL.
character_set_name	sql_identifier	Applies to a feature not available in PostgreSQL.
collation_catalog	sql_identifier	The name of the catalog (database) containing the parameter’s collation. Always NULL for parameter data types.
collation_schema	sql_identifier	The name of the schema containing the parameter’s collation. Always NULL for parameter data types.
collation_name	sql_identifier	The name of the parameter’s collation. Always NULL for parameter data types.
numeric_precision	cardinal_number	The declared or implicit precision of numeric types. Always NULL for parameter data types.
numeric_precision_radix	cardinal_number	The base (2 or 10) in which numeric precision and scale are expressed. Always NULL for parameter data types.
numeric_scale	cardinal_number	The scale (digits to the right of the decimal) of numeric data types. Always NULL for parameter data types.
datetime_precision	cardinal_number	The fractional seconds precision of date/time/timestamp/interval types. Always NULL for parameter data types.
interval_type	character_data	Specifies which interval fields are included in interval data types. Always NULL for parameter data types.
interval_precision	cardinal_number	The number of fractional digits (precision) allowed for a data type. Always NULL for parameter data types.
udt_catalog	sql_identifier	The name of the database in which the parameter’s data type is defined.
udt_schema	sql_identifier	The name of the schema in which the parameter’s data type is defined.
udt_name	sql_identifier	The name of the parameter’s data type.
scope_catalog	sql_identifier	Applies to a feature that is not available in PostgreSQL.
scope_schema	sql_identifier	Applies to a feature that is not available in PostgreSQL.
scope_name	sql_identifier	Applies to a feature that is not available in PostgreSQL.
maximum_cardinality	cardinal_number	The maximum cardinality of the array. Always NULL because PostgreSQL arrays have unlimited cardinality.
dtd_identifier	sql_identifier	A unique identifier for the parameter’s data type descriptor.
parameter_default	character_data	The default expression of the parameter. NULL – Not available.