current host and dbname info

From: "Joe Conway" <jconway2(at)home(dot)com>
To: "Postgres SQL list" <pgsql-sql(at)postgresql(dot)org>
Subject: current host and dbname info
Date: 2001-01-28 05:40:27
Message-ID: 024c01c088ec$d200a190$0705a8c0@jecw2k1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

I've been searching the docs and been unable to find the answer to this --
is there a way to get the current database server host tcpip address,
postmaster port, and database name from a SQL query?

I'd like to access those from within a plpgsql function without having to
create and populate some sort of identification table.

Thanks,

Joe

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Ferruccio Zamuner 2001-01-28 10:34:35 Multicolumn primary keys and multicolumn foreign keys
Previous Message John Reid 2001-01-28 03:58:35 Re: abstract data types?