Received: from trade-india.com ([130.94.20.28]) by postgresql.org (8.11.3/8.11.4) with SMTP id fBLAcwm65743 for ; Fri, 21 Dec 2001 05:38:58 -0500 (EST) (envelope-from mallah@trade-india.com) Received: (qmail 29219 invoked from network); 21 Dec 2001 10:51:45 -0000 Received: from ptil-235-129-del.primus-india.net (HELO trade-india.com) (203.196.129.235) by 130.94.22.209 with SMTP; 21 Dec 2001 10:51:45 -0000 Message-ID: <3C231221.CAD4F38A@trade-india.com> Date: Fri, 21 Dec 2001 16:12:41 +0530 From: mallah@trade-india.com Reply-To: mallah_rajesh@yahoo.com X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.4.2-2 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: getting the name of currenlty connected host.. Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200112/226 X-Sequence-Number: 6048 Hi folks, Is there any way to get the information about the host that is executing the sql. like tradein_clients=> select current_user; current_user -------------- tradein (1 row) returns the current user, is there anything that would return the host information from which the current user is connected? regds. Mallah.