Properties

Name: parameters 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

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 
Total: 31 column(s)

SQL


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