<!--

$Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.102 2002/06/1502:59:55 thomas Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.103 2002/06/1520:03:51 momjian Exp $

PostgreSQL documentation

-->

<entry>name of current schema</entry>

</row>

<row>

<entry><function>current_schemas()</function></entry>

<entry><function>current_schemas(boolean)</function></entry>

<entry><type>name[]</type></entry>

<entry>names of schemas in search path</entry>

<entry>names of schemas in search path optionally including implicit schemas</entry>

</row>

</tbody>

</tgroup>

at the front of the search path (or NULL if the search path is

empty). This is the schema that will be used for any tables or

other named objects that are created without specifying a target schema.

<function>current_schemas</function> returns an array of the names of all

schemas presently in the search path.Note that these functions show

is being searched implicitly, it is not listed.

<function>current_schemas(boolean)</function> returns an array of the names of all

schemas presently in the search path.The boolean option determines whether or not

path returned.

</para>

<table>

current_schemas(PG_FUNCTION_ARGS)

{

List*search_path=fetch_search_path(false);

List*search_path=fetch_search_path(PG_GETARG_BOOL(0));

intnnames=length(search_path);

Datum*names;

inti;

DATA(insertOID=1402 (current_schemaPGNSPPGUID12ffftfs019"0"10000100current_schema-_null_ ));

DESCR("current schema name");

DATA(insertOID=1403 (current_schemasPGNSPPGUID12ffftfs01003"0"10000100current_schemas-_null_ ));

DATA(insertOID=1403 (current_schemasPGNSPPGUID12ffftfs11003"16"10000100current_schemas-_null_ ));

DESCR("current schema search list");

DATA(insertOID=1404 (overlayPGNSPPGUID14ffftfi425"25 25 23 23"10000100"select substring($1, 1, ($3 - 1)) || $2 || substring($1, ($3 + $4))"-_null_ ));