Re: host name? - Mailing list pgsql-admin

From Igor Neyman
Subject Re: host name?
Date
Msg-id F4C27E77F7A33E4CA98C19A9DC6722A201ADF6C0@EXCHANGE.corp.perceptron.com
Whole thread Raw
In response to Re: host name?  ("Andy Shellam (Mailing Lists)" <andy.shellam-lists@mailnetwork.co.uk>)
Responses Re: host name?  (Ray Stell <stellr@cns.vt.edu>)
List pgsql-admin
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@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] 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?

pgsql-admin by date:

Previous
From: David Bear
Date:
Subject: kerberized odbc driver
Next
From: Franco
Date:
Subject: UNSUBSCRIBE