diff options
author | Bruce Momjian <bruce@momjian.us> | 2002-08-20 04:46:00 +0000 |
---|---|---|
committer | Bruce Momjian <bruce@momjian.us> | 2002-08-20 04:46:00 +0000 |
commit | de9801fc62ba9ed905c2f20686459a206d453453 (patch) | |
tree | e6ed5e64ba97e2156230373abb038af9138149be /doc/src | |
parent | f736fdb0222ded716bd4f0cdddc06158773d9bc1 (diff) | |
download | postgresql-de9801fc62ba9ed905c2f20686459a206d453453.tar.gz postgresql-de9801fc62ba9ed905c2f20686459a206d453453.zip |
Add current_database().
> Quick system function to pull out the current database.
>
> I've used this a number of times to allow stored procedures to find out
> where they are. Especially useful for those that do logging or hit a
> remote server.
>
> It's called current_database() to match with current_user().
It's also a necessity for an informational schema. The catalog
(database) name is required in a number of places.
Rod Taylor
Diffstat (limited to 'doc/src')
-rw-r--r-- | doc/src/sgml/func.sgml | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index bf2ce4667e2..fddc65e84d3 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.112 2002/08/16 23:01:18 tgl Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.113 2002/08/20 04:45:59 momjian Exp $ PostgreSQL documentation --> @@ -5082,6 +5082,11 @@ SELECT NULLIF(value, '(none)') ... <entry><type>name[]</type></entry> <entry>names of schemas in search path optionally including implicit schemas</entry> </row> + <row> + <entry><function>current_database()</function></entry> + <entry><type>name</type></entry> + <entry>name of current database</entry> + </row> </tbody> </tgroup> </table> |