/hostname
>
> Igor
>
>
>
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Igor Neyman
> Sent: Monday, February 26, 2007 10:29 AM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] host name?
>
>
> Is there a functi
Igor Neyman wrote:
> But besides having ip address (instead of machine name), it doesn't
> have clent program name connected to PG.
That information is not available to the server.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)
PM
To: Igor Neyman
Cc: Andy Shellam (Mailing Lists); pgsql-admin@postgresql.org
Subject: Re: [ADMIN] host name?
not sure how to resolve the name, but maybe this is close
enough:
select usename, client_addr from pg_catalog.pg_stat_activity;
On Mon, Feb 26, 2007 at 11:47:13AM -0500, Igor Neyman
Igor Neyman
Cc: Andy Shellam (Mailing Lists); pgsql-admin@postgresql.org
Subject: Re: [ADMIN] host name?
not sure how to resolve the name, but maybe this is close
enough:
select usename, client_addr from pg_catalog.pg_stat_activity;
On Mon, Feb 26, 2007 at 11:47:13AM -0500, Igor Neyman wrote:
lto:[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
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
-admin@postgresql.org
Subject: [ADMIN] host name?
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
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?
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
