On Fri, Aug 07, 2009 at 12:08:45PM -0700, Gauthier, Dave wrote: > Running 8.3.4 on Linux. > > From inside a stored procedure, is there a way to capture the linux > user (environment var = $USER) that is attached to the DB?
Not really, what if they were connecting over the network from a device that doesn't have "users"? Maybe the "current_user" variable[1] helps? -- Sam http://samason.me.uk/ [1] http://www.postgresql.org/docs/current/static/functions-info.html -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
