[SQL] getting the OS user name

2012-04-23 Thread John Fabiani
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.  

Johnf

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql


Re: [SQL] getting the OS user name

2012-04-23 Thread Andreas Kretschmer
John Fabiani  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
-- 
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.  (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.  N 51.05082°, E 13.56889°

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql


Re: [SQL] getting the OS user name

2012-04-23 Thread John Fabiani
On Monday, April 23, 2012 04:52:25 PM Andreas Kretschmer wrote:
> John Fabiani  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

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql