Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 2225F9FB8E4 for ; Mon, 26 Feb 2007 11:57:04 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 43405-07 for ; Mon, 26 Feb 2007 11:56:56 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from cooma-1.andyshellam.eu (cooma-1.andyshellam.eu [82.165.38.62]) by postgresql.org (Postfix) with ESMTP id D9DA89FB8BB for ; Mon, 26 Feb 2007 11:56:56 -0400 (AST) Received: from [213.146.143.243] (port=46034 helo=[172.16.208.165]) by cooma-1.andyshellam.eu with esmtpa (Exim 4.66) (envelope-from ) id 1HLiFx-0006pH-5I; Mon, 26 Feb 2007 15:59:17 +0000 Message-ID: <45E30326.20107@mailnetwork.co.uk> Date: Mon, 26 Feb 2007 15:56:22 +0000 From: "Andy Shellam (Mailing Lists)" User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: Igor Neyman CC: pgsql-admin@postgresql.org Subject: Re: host name? References: In-Reply-To: Content-Type: multipart/alternative; boundary="------------090305010608060103060003" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.152 tagged_above=0 required=5 tests=AWL, BAYES_60, HTML_MESSAGE, HTML_TITLE_EMPTY, SPF_PASS X-Spam-Level: * X-Archive-Number: 200702/323 X-Sequence-Number: 24788 This is a multi-part message in MIME format. --------------090305010608060103060003 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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? --------------090305010608060103060003 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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?

--------------090305010608060103060003--