Re: host name?

["Igor Neyman" <ineyman(at)perceptron(dot)com>]

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: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Andy Shellam (Mailing Lists)
Sent: Monday, February 26, 2007 10:56 AM
To: Igor Neyman
Cc: pgsql-admin(at)postgresql(dot)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?