specific_catalogsql_identifier

Name of the database containing the function (always the current database)

specific_schemasql_identifier

Name of the schema containing the function

specific_namesql_identifier

The “specific name” of the function. This is a name that uniquely identifies the function in the schema, even if the real name of the function is overloaded. The format of the specific name is not defined, it should only be used to compare it to other instances of specific routine names.

routine_catalogsql_identifier

Name of the database containing the function (always the current database)

routine_schemasql_identifier

Name of the schema containing the function

routine_namesql_identifier

Name of the function (might be duplicated in case of overloading)

routine_typecharacter_data

FUNCTION for a function, PROCEDURE for a procedure

module_catalogsql_identifier

Applies to a feature not available in Postgres Pro

module_schemasql_identifier

Applies to a feature not available in Postgres Pro

module_namesql_identifier

Applies to a feature not available in Postgres Pro

udt_catalogsql_identifier

Applies to a feature not available in Postgres Pro

udt_schemasql_identifier

Applies to a feature not available in Postgres Pro

udt_namesql_identifier

Applies to a feature not available in Postgres Pro

data_typecharacter_data

Return data type of the function, if it is a built-in type, or ARRAY if it is some array (in that case, see the view element_types), else USER-DEFINED (in that case, the type is identified in type_udt_name and associated columns). Null for a procedure.

character_maximum_lengthcardinal_number

Always null, since this information is not applied to return data types in Postgres Pro

character_octet_lengthcardinal_number

Always null, since this information is not applied to return data types in Postgres Pro

character_set_catalogsql_identifier

Applies to a feature not available in Postgres Pro

character_set_schemasql_identifier

Applies to a feature not available in Postgres Pro

character_set_namesql_identifier

Applies to a feature not available in Postgres Pro

collation_catalogsql_identifier

Always null, since this information is not applied to return data types in Postgres Pro

collation_schemasql_identifier

Always null, since this information is not applied to return data types in Postgres Pro

collation_namesql_identifier

Always null, since this information is not applied to return data types in Postgres Pro

numeric_precisioncardinal_number

Always null, since this information is not applied to return data types in Postgres Pro

numeric_precision_radixcardinal_number

Always null, since this information is not applied to return data types in Postgres Pro

numeric_scalecardinal_number

Always null, since this information is not applied to return data types in Postgres Pro

datetime_precisioncardinal_number

Always null, since this information is not applied to return data types in Postgres Pro

interval_typecharacter_data

Always null, since this information is not applied to return data types in Postgres Pro

interval_precisioncardinal_number

Always null, since this information is not applied to return data types in Postgres Pro

type_udt_catalogsql_identifier

Name of the database that the return data type of the function is defined in (always the current database). Null for a procedure.

type_udt_schemasql_identifier

Name of the schema that the return data type of the function is defined in. Null for a procedure.

type_udt_namesql_identifier

Name of the return data type of the function. Null for a procedure.

scope_catalogsql_identifier

Applies to a feature not available in Postgres Pro

scope_schemasql_identifier

Applies to a feature not available in Postgres Pro

scope_namesql_identifier

Applies to a feature not available in Postgres Pro

maximum_cardinalitycardinal_number

Always null, because arrays always have unlimited maximum cardinality in Postgres Pro

dtd_identifiersql_identifier

An identifier of the data type descriptor of the return data type of this function, unique among the data type descriptors pertaining to the function. This is mainly useful for joining with other instances of such identifiers. (The specific format of the identifier is not defined and not guaranteed to remain the same in future versions.)

routine_bodycharacter_data

If the function is an SQL function, then SQL, else EXTERNAL.

routine_definitioncharacter_data

The source text of the function (null if the function is not owned by a currently enabled role). (According to the SQL standard, this column is only applicable if routine_body is SQL, but in Postgres Pro it will contain whatever source text was specified when the function was created.)

external_namecharacter_data

If this function is a C function, then the external name (link symbol) of the function; else null. (This works out to be the same value that is shown in routine_definition.)

external_languagecharacter_data

The language the function is written in

parameter_stylecharacter_data

Always GENERAL (The SQL standard defines other parameter styles, which are not available in Postgres Pro.)

is_deterministicyes_or_no

If the function is declared immutable (called deterministic in the SQL standard), then YES, else NO. (You cannot query the other volatility levels available in Postgres Pro through the information schema.)

sql_data_accesscharacter_data

Always MODIFIES, meaning that the function possibly modifies SQL data. This information is not useful for Postgres Pro.

is_null_callyes_or_no

If the function automatically returns null if any of its arguments are null, then YES, else NO. Null for a procedure.

sql_pathcharacter_data

Applies to a feature not available in Postgres Pro

schema_level_routineyes_or_no

Always YES (The opposite would be a method of a user-defined type, which is a feature not available in Postgres Pro.)

max_dynamic_result_setscardinal_number

Applies to a feature not available in Postgres Pro

is_user_defined_castyes_or_no

Applies to a feature not available in Postgres Pro

is_implicitly_invocableyes_or_no

Applies to a feature not available in Postgres Pro

security_typecharacter_data

If the function runs with the privileges of the current user, then INVOKER, if the function runs with the privileges of the user who defined it, then DEFINER.

to_sql_specific_catalogsql_identifier

Applies to a feature not available in Postgres Pro

to_sql_specific_schemasql_identifier

Applies to a feature not available in Postgres Pro

to_sql_specific_namesql_identifier

Applies to a feature not available in Postgres Pro

as_locatoryes_or_no

Applies to a feature not available in Postgres Pro

createdtime_stamp

Applies to a feature not available in Postgres Pro

last_alteredtime_stamp

Applies to a feature not available in Postgres Pro

new_savepoint_levelyes_or_no

Applies to a feature not available in Postgres Pro

is_udt_dependentyes_or_no

Currently always NO. The alternative YES applies to a feature not available in Postgres Pro.

result_cast_from_data_typecharacter_data

Applies to a feature not available in Postgres Pro

result_cast_as_locatoryes_or_no

Applies to a feature not available in Postgres Pro

result_cast_char_max_lengthcardinal_number

Applies to a feature not available in Postgres Pro

result_cast_char_octet_lengthcardinal_number

Applies to a feature not available in Postgres Pro

result_cast_char_set_catalogsql_identifier

Applies to a feature not available in Postgres Pro

result_cast_char_set_schemasql_identifier

Applies to a feature not available in Postgres Pro

result_cast_char_set_namesql_identifier

Applies to a feature not available in Postgres Pro

result_cast_collation_catalogsql_identifier

Applies to a feature not available in Postgres Pro

result_cast_collation_schemasql_identifier

Applies to a feature not available in Postgres Pro

result_cast_collation_namesql_identifier

Applies to a feature not available in Postgres Pro

result_cast_numeric_precisioncardinal_number

Applies to a feature not available in Postgres Pro

result_cast_numeric_precision_radixcardinal_number

Applies to a feature not available in Postgres Pro

result_cast_numeric_scalecardinal_number

Applies to a feature not available in Postgres Pro

result_cast_datetime_precisioncardinal_number

Applies to a feature not available in Postgres Pro

result_cast_interval_typecharacter_data

Applies to a feature not available in Postgres Pro

result_cast_interval_precisioncardinal_number

Applies to a feature not available in Postgres Pro

result_cast_type_udt_catalogsql_identifier

Applies to a feature not available in Postgres Pro

result_cast_type_udt_schemasql_identifier

Applies to a feature not available in Postgres Pro

result_cast_type_udt_namesql_identifier

Applies to a feature not available in Postgres Pro

result_cast_scope_catalogsql_identifier

Applies to a feature not available in Postgres Pro

result_cast_scope_schemasql_identifier

Applies to a feature not available in Postgres Pro

result_cast_scope_namesql_identifier

Applies to a feature not available in Postgres Pro

result_cast_maximum_cardinalitycardinal_number

Applies to a feature not available in Postgres Pro

result_cast_dtd_identifiersql_identifier

Applies to a feature not available in Postgres Pro