| From: | Roberto Mello <rmello(at)cc(dot)usu(dot)edu> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Getting PID of current logged user |
| Date: | 2002-06-05 18:40:30 |
| Message-ID: | 20020605184030.GC1307@cc.usu.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2002-06-05 18:53:32 | Re: Indexing Metaphone? |
| Previous Message | Richard Poole | 2002-06-05 18:39:50 | Re: Indexing Metaphone? |