O Richard Huxton έγραψε στις Nov 17, 2004 :
Riccardo G. Facchini wrote:
hi all,
is there a way to determine the session id on a database session?
I would need to have a unique number whenever a session is started, and have this available as a function or view result.
Why not SELECT pg_backend_pid(); ??
This is guaranteed to be unique while connected, but if you want to track sessions over time isn't guaranteed to be. So, if you might have pid=1234 now and also a month ago in a different session (especially if you had a server reboot in-between).
Of course, if Riccardo doesn't need that, the pid is fine.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
