Name: | parameters |
Owner: | postgres |
Has rules: | |
Has Triggers: | |
Comment: |
Name | Type | Length | |
|
specific_catalog | sql_identifier | -1 |
|
specific_schema | sql_identifier | -1 |
|
specific_name | sql_identifier | -1 |
|
ordinal_position | cardinal_number | -1 |
|
parameter_mode | character_data | -1 |
|
is_result | character_data | -1 |
|
as_locator | character_data | -1 |
|
parameter_name | sql_identifier | -1 |
|
data_type | character_data | -1 |
|
character_maximum_length | cardinal_number | -1 |
|
character_octet_length | cardinal_number | -1 |
|
character_set_catalog | sql_identifier | -1 |
|
character_set_schema | sql_identifier | -1 |
|
character_set_name | sql_identifier | -1 |
|
collation_catalog | sql_identifier | -1 |
|
collation_schema | sql_identifier | -1 |
|
collation_name | sql_identifier | -1 |
|
numeric_precision | cardinal_number | -1 |
|
numeric_precision_radix | cardinal_number | -1 |
|
numeric_scale | cardinal_number | -1 |
|
datetime_precision | cardinal_number | -1 |
|
interval_type | character_data | -1 |
|
interval_precision | character_data | -1 |
|
udt_catalog | sql_identifier | -1 |
|
udt_schema | sql_identifier | -1 |
|
udt_name | sql_identifier | -1 |
|
scope_catalog | sql_identifier | -1 |
|
scope_schema | sql_identifier | -1 |
|
scope_name | sql_identifier | -1 |
|
maximum_cardinality | cardinal_number | -1 |
|
dtd_identifier | sql_identifier | -1 |
CREATE VIEW parameters AS
SELECT (current_database())::sql_identifier AS specific_catalog, (ss.n_nspname)::sql_identifier AS specific_schema, ((((ss.proname)::text || '_'::text) || (ss.p_oid)::text))::sql_identifier AS specific_name, ((ss.x).n)::cardinal_number AS ordinal_position, (CASE WHEN (ss.proargmodes IS NULL) THEN 'IN'::text WHEN (ss.proargmodes[(ss.x).n] = 'i'::"char") THEN 'IN'::text WHEN (ss.proargmodes[(ss.x).n] = 'o'::"char") THEN 'OUT'::text WHEN (ss.proargmodes[(ss.x).n] = 'b'::"char") THEN 'INOUT'::text ELSE NULL::text END)::character_data AS parameter_mode, ('NO'::character varying)::character_data AS is_result, ('NO'::character varying)::character_data AS as_locator, (NULLIF(ss.proargnames[(ss.x).n], ''::text))::sql_identifier AS parameter_name, (CASE WHEN ((t.typelem <> (0)::oid) AND (t.typlen = -1)) THEN 'ARRAY'::text WHEN (nt.nspname = 'pg_catalog'::name) THEN format_type(t.oid, NULL::integer) ELSE 'USER-DEFINED'::text END)::character_data AS data_type, (NULL::integer)::cardinal_number AS character_maximum_length, (NULL::integer)::cardinal_number AS character_octet_length, (NULL::character varying)::sql_identifier AS character_set_catalog, (NULL::character varying)::sql_identifier AS character_set_schema, (NULL::character varying)::sql_identifier AS character_set_name, (NULL::character varying)::sql_identifier AS collation_catalog, (NULL::character varying)::sql_identifier AS collation_schema, (NULL::character varying)::sql_identifier AS collation_name, (NULL::integer)::cardinal_number AS numeric_precision, (NULL::integer)::cardinal_number AS numeric_precision_radix, (NULL::integer)::cardinal_number AS numeric_scale, (NULL::integer)::cardinal_number AS datetime_precision, (NULL::character varying)::character_data AS interval_type, (NULL::character varying)::character_data AS interval_precision, (current_database())::sql_identifier AS udt_catalog, (nt.nspname)::sql_identifier AS udt_schema, (t.typname)::sql_identifier AS udt_name, (NULL::character varying)::sql_identifier AS scope_catalog, (NULL::character varying)::sql_identifier AS scope_schema, (NULL::character varying)::sql_identifier AS scope_name, (NULL::integer)::cardinal_number AS maximum_cardinality, ((ss.x).n)::sql_identifier AS dtd_identifier FROM pg_type t, pg_namespace nt, (SELECT n.nspname AS n_nspname, p.proname, p.oid AS p_oid, p.proargnames, p.proargmodes, _pg_expandarray(COALESCE(p.proallargtypes, (p.proargtypes)::oid[])) AS x FROM pg_namespace n, pg_proc p WHERE ((n.oid = p.pronamespace) AND (pg_has_role(p.proowner, 'USAGE'::text) OR has_function_privilege(p.oid, 'EXECUTE'::text)))) ss WHERE ((t.oid = (ss.x).x) AND (t.typnamespace = nt.oid));
ALTER TABLE information_schema.parameters OWNER TO postgres;
See Also
List of views