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
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) |