Description

pg_backend_pid returns the process ID (PID) of the PostgreSQL backend process which is handling the connection. This is an integer that uniquely identifies this client connection among all others connected to the same PostgreSQL server. It can also be used with notifications (see pg_listen).

Arguments

Return Value

An integer process ID (PID). This is the ID of a process running on the server, not on the client system (unless they are the same).

Notes

This command does not contact the database server - it uses information supplied by the server at connection time.

This command uses or emulates the PostgreSQL libpq function PQbackendPID.

This command was added in pgtclng-2.0.0 and in pgintcl-3.4.0.