Re: Unique Session ID in PGSQL?

Pavel Stehule wrote:
>> Is there any function in PGSQL that returns an unique Session
>> identifier of the actual session?
>> For example a Bigint, or GUID, or etc?
>> Can I get the living Session identifiers from PG?
>
> try
>
> postgres=# select pg_backend_pid();
>  pg_backend_pid
> ----------------
>           17327
> (1 row)

I don't totally understand the intended use, but process IDs have the
problem that they will get reused eventually.

So if that's not good enough, you can construct a session ID like
%c in log_line_prefix with the query found in the documentation:

http://www.postgresql.org/docs/current/static/runtime-config-logging.html#GUC-LOG-LINE-PREFIX

Yours,
Laurenz Albe