How to determine current database?

[Ron St-Pierre]

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:
UPDATE tblUpdates SET xxx=1234 WHERE pg_current = TRUE;
or
UPDATE tblUpdates SET xxx=1234 WHERE pg_current = thisDBname;

We have about 15 databases all set up identically and when the structure
changes I run scripts to update them to ensure that they are all the
same. I need to create two new databases which have slight changes
(different default values - for now) and want to be able to have my
scripts be able to determine which database their running from.

Thanks

Ron
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

[Joe Conway]

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.

See:
http://www.postgresql.org/docs/7.3/s...ions-misc.html

HTH,

Joe

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

[Eric Ridge]

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
UPDATE tblUpdates SET xxx=1234 WHERE pg_current = TRUE;
or
UPDATE tblUpdates SET xxx=1234 WHERE pg_current = thisDBname;

We have about 15 databases all set up identically and when the
structure changes I run scripts to update them to ensure that they are
all the same. I need to create two new databases which have slight
changes (different default values - for now) and want to be able to
have my scripts be able to determine which database their running
from.

Thanks

Ron
---------------------------(end of
broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to
ma*******@postgresql.org

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

[Tom Lane]

Ron St-Pierre <rs*******@syscor.com> writes:

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

See current_database():
http://www.postgresql.org/docs/7.4/s...ions-misc.html

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Ron St-Pierre]

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/s...ions-misc.html

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

Ron
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html