Обсуждение: Getting PID of current logged user

Поиск
Список
Период
Сортировка

Getting PID of current logged user

От
Roberto Mello
Дата:
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