Re: [GENERAL] Print database name

2007-04-05 Thread Martijn van Oosterhout
On Thu, Apr 05, 2007 at 11:17:49AM -0400, Jaime Silvela wrote: > 1. Sorry, that was an accident. I sent a new thread to the list and it > didn't make it. Thinking I had gotten the address wrong, I "replied to" > this thread and accidentally hit send, forgetting to change the subject. > My apolog

Re: [GENERAL] Print database name

2007-04-05 Thread Jaime Silvela
1. Sorry, that was an accident. I sent a new thread to the list and it didn't make it. Thinking I had gotten the address wrong, I "replied to" this thread and accidentally hit send, forgetting to change the subject. My apologies, no hijacking was intended. 2. Close. The database was generally

Re: [GENERAL] Print database name

2007-04-05 Thread Tom Lane
Jaime Silvela <[EMAIL PROTECTED]> writes: > Below you can see the log on starting, after a kill -9 of a process > brought Postgres down. > After letting postgres run for a while, it seems to have fixed itself, > and now the log does not suggest any corruption, and I can access it > locally. Howe

Re: [GENERAL] Print database name

2007-04-05 Thread Jaime Silvela
I know you've probably discussed this in many places, but I have a crash right now I need to recover from, and I'm not finding documentation that fast. Where should I go? Below you can see the log on starting, after a kill -9 of a process brought Postgres down. After letting postgres run for a

Re: [GENERAL] Print database name

2007-04-05 Thread Michael Fuhr
On Thu, Apr 05, 2007 at 08:51:28AM -0400, Woody Woodring wrote: > Is there a sql command to print out which database I am connected to? SELECT current_database(); See "System Information Functions" in the documentation for other such functions. http://www.postgresql.org/docs/8.2/interactive/func

[GENERAL] Print database name

2007-04-05 Thread Woody Woodring
Is there a sql command to print out which database I am connected to? I am using "psql -f sqlFile" in a sh script to up date tables on multiple databases. I would like to have the sqlFile display the db name so I would know which output lines go with each db without having to count the output lin