Received: from femail4.sdc1.sfba.home.com (femail4.sdc1.sfba.home.com [24.0.95.84]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0S5erq26622 for ; Sun, 28 Jan 2001 00:40:53 -0500 (EST) (envelope-from jconway2@home.com) Received: from jecw2k1 ([24.0.42.111]) by femail4.sdc1.sfba.home.com (InterMail vM.4.01.03.00 201-229-121) with SMTP id <20010128053840.OCSL11986.femail4.sdc1.sfba.home.com@jecw2k1> for ; Sat, 27 Jan 2001 21:38:40 -0800 Message-ID: <024c01c088ec$d200a190$0705a8c0@jecw2k1> Reply-To: "Joe Conway" From: "Joe Conway" To: "Postgres SQL list" References: Subject: current host and dbname info Date: Sat, 27 Jan 2001 21:40:27 -0800 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Archive-Number: 200101/424 X-Sequence-Number: 1100 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