Re: current_database()

From: Rod Taylor <rbt(at)zort(dot)ca>
To: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: current_database()
Date: 2002-08-07 01:19:07
Message-ID: 1028683148.93791.11.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

On Tue, 2002-08-06 at 21:15, Rod Taylor wrote:
> 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.

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2002-08-07 01:40:53 Re: CLUSTER patch and regression test
Previous Message Rod Taylor 2002-08-07 01:17:41 Foreign key in pg_dump / psql