You are right, wrong question. What I really want to know is formulated in my next message. Which is: based on program (connected to PG) name find the machine name it runs on. For those familiar with Oracle, it's program, machine columns in v$session view.
Igor ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andy Shellam (Mailing Lists) Sent: Monday, February 26, 2007 10:56 AM To: Igor Neyman Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] host name? Igor Neyman wrote: Is there a function (or catalog view) that I can call in psql and that will tell me host name of the machine on which Postgres database is running? Igor Surely you need to know this to connect to it in the first place?