| From: | "Igor Neyman" <ineyman(at)perceptron(dot)com> |
|---|---|
| To: | "Andy Shellam \(Mailing Lists\)" <andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk> |
| Cc: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: host name? |
| Date: | 2007-02-26 16:47:13 |
| Message-ID: | F4C27E77F7A33E4CA98C19A9DC6722A201ADF6C0@EXCHANGE.corp.perceptron.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Franco | 2007-02-26 16:53:35 | UNSUBSCRIBE |
| Previous Message | Igor Neyman | 2007-02-26 16:20:02 | Re: host name? |