Re: current_database()

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Rod Taylor <rbt(at)zort(dot)ca>
Cc: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: current_database()
Date: 2002-08-20 04:46:04
Message-ID: 200208200446.g7K4k4f21967@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches


Patch applied with docs. Thanks.

---------------------------------------------------------------------------

Rod Taylor wrote:
> 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.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2002-08-20 04:47:57 Re: pg_stat_reset round 4
Previous Message Bruce Momjian 2002-08-20 03:57:31 Re: Documentation update (pg_get_fkeydef, current_database)