Re: How to determine current database?

Eric Ridge wrote:

> On Feb 13, 2004, at 6:05 PM, Ron St-Pierre wrote:
>
>> I am using postgres 7.3.4 and need to be able to determine which
>> database a query is being run in (from a script). pg_database lists
>> databases but doesn't tell me which one is currently active. Is there
>> a query I can use along the lines of:
>
>
> The built-in function "current_database()" returns the current
> database name.
>
> =# select current_database();
>  current_database
> ------------------
>  testing
> (1 row)
>
> Use it in your update statements too.
>
> eric

That's exactly what I need!

Joe Conway wrote:

> See:
> http://www.postgresql.org/docs/7.3/static/functions-misc.html


Thanks guys. I was searching the docs looking for functions starting
with pg_

Ron