| 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: | Whole Thread | Raw Message | 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) |