Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id 9D31012DEACC
	for <pgsql-sql@postgresql.org>; Mon, 23 Apr 2012 11:58:16 -0300 (ADT)
Received: from [76.14.161.106] (helo=newserver.jfcomputer.com)
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <johnf@jfcomputer.com>) id 1SMKiT-0008C3-Ra
	for pgsql-sql@postgresql.org; Mon, 23 Apr 2012 14:58:15 +0000
Received: from localhost (unknown [127.0.0.1])
	by newserver.jfcomputer.com (Postfix) with ESMTP id 649DF12215
	for <pgsql-sql@postgresql.org>; Mon, 23 Apr 2012 14:57:58 +0000 (UTC)
X-Virus-Scanned: amavisd-new at site
Received: from newserver.jfcomputer.com ([127.0.0.1])
	by localhost (linux-jfp8.site [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id GdfNxJW5ba0C for <pgsql-sql@postgresql.org>;
	Mon, 23 Apr 2012 07:57:56 -0700 (PDT)
Received: from linux-12.localnet (unknown [192.168.1.254])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	(Authenticated sender: johnf@jfcomputer.com)
	by newserver.jfcomputer.com (Postfix) with ESMTPSA id F02B910F5E
	for <pgsql-sql@postgresql.org>; Mon, 23 Apr 2012 07:57:55 -0700 (PDT)
From: John Fabiani <johnf@jfcomputer.com>
To: pgsql-sql@postgresql.org
Subject: Re: getting the OS user name
Date: Mon, 23 Apr 2012 07:57:51 -0700
Message-ID: <2787058.GyMcXj9ES3@linux-12>
User-Agent: KMail/4.7.2 (Linux/3.1.9-1.4-desktop; KDE/4.7.2; x86_64; ; )
In-Reply-To: <20120423145225.GA28321@tux>
References: <4654350.cBryTEqMC6@linux-12> <20120423145225.GA28321@tux>
MIME-Version: 1.0
Content-Transfer-Encoding: 7Bit
Content-Type: text/plain; charset="us-ascii"
X-Host-Lookup-Failed: Reverse DNS lookup failed for 76.14.161.106 (failed)
X-Pg-Spam-Score: 1.6 (+)
X-Archive-Number: 201204/46
X-Sequence-Number: 36523

On Monday, April 23, 2012 04:52:25 PM Andreas Kretschmer wrote:
> John Fabiani <johnf@jfcomputer.com> wrote:
> > Hi,
> > In my app it is possible to login as one name and use a different name
> > to
> > login to postgres.
> > 
> > Is it possible to get the actual OS login name using plsql.
> 
> Since you can login to an remote database server: no.
> 
> 
> Andreas

Ahhh! never considered that issue.

Thanks
Johnf