Home > mailing lists

Getting PID of current logged user - Mailing list pgsql-sql

From	Roberto Mello
Subject	Getting PID of current logged user
Date	June 5, 2002 17:38:49
Msg-id	20020605184030.GC1307@cc.usu.edu Whole thread Raw
List	pgsql-sql

Tree view

Hi all,

On http://www.postgresql.org/idocs/index.php?monitoring-stats.html I found
pg_stat_get_backend_userid(integer) that will give me the user id of the
current logged in user. But I need to pass the oid of the backend.

I see a function to return the oid of all backends, but how do I find out
the oid of _my_ backend (say I'm executing this in a PL/pgSQL function)?

Thanks,

-Roberto

-- 
+----| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU -
http://www.brasileiro.net/      http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer

pgsql-sql by date:

From: Roberto Mello
Date: 05 June 2002, 17:22:37
Subject: extract and variables in PL/pgSQL

From: Richard Poole
Date: 05 June 2002, 17:41:24
Subject: Re: Indexing Metaphone?

Getting PID of current logged user - Mailing list pgsql-sql

Previous

Next