<!-- $PostgreSQL: pgsql/doc/src/sgml/information_schema.sgml,v 1.13 2003/12/13 23:59:06 neilc Exp $ -->

<!-- $PostgreSQL: pgsql/doc/src/sgml/information_schema.sgml,v 1.14 2004/01/24 23:45:13 tgl Exp $ -->

<chapter id="information-schema">

<title>The Information Schema</title>

<para>

The view <literal>parameters</literal> contains information about

the parameters (arguments) all functions in the current database.

the parameters (arguments)ofall functions in the current database.

Only those functions are shown that the current user has access to

(by way of being the owner or having some privilege).

</para>

<entry><literal>parameter_mode</literal></entry>

<entry><type>character_data</type></entry>

<entry>

Always <literal>IN</literal>, meaning input parameter (In the

future there might be other parameter modes.)

Always <literal>IN</literal>, meaning input parameter (in the

future there might be other parameter modes)

</entry>

</row>

<row>

<entry><literal>parameter_name</literal></entry>

<entry><type>sql_identifier</type></entry>

<entry>Always null, since <productname>PostgreSQL</> does not support named parameters</entry>

<entry>Name of the parameter, or null if the parameter has no name</entry>

</row>

<row>

CAST('IN'AS character_data)AS parameter_mode,

CAST('NO'AS character_data)AS is_result,

CAST('NO'AS character_data)AS as_locator,

CAST(nullAS sql_identifier)AS parameter_name,

CAST(NULLIF(p.proargnames[pos.n],'')AS sql_identifier)AS parameter_name,

CAST(

CASE WHENt.typelem<>0ANDt.typlen=-1 THEN'ARRAY'

WHENnt.nspname='pg_catalog' THEN format_type(t.oid,null)