PostgreSQL Session Functions

The PostgreSQL current_catalog returns the name of the current database.

The PostgreSQL current_database() function returns the name of the current database.

The PostgreSQL current_query() function returns one or more executing statements submitted by the current client.

The PostgreSQL current_role returns the name of the current user (the user of the current execution context).

The PostgreSQL current_schema() function returns the name of the current schema.

The PostgreSQL function returns all schema names on the currently valid search path in order of priority.

The PostgreSQL current_user returns the name of the current user (the user of the current execution context).

The PostgreSQL inet_client_port() function returns the current client’s IP port number.

The PostgreSQL inet_server_addr() function returns the IP address of the server that accepts the current connection, or if the current connection is connected through a Unix socket NULL.

The PostgreSQL inet_server_port() function returns the IP port of the server that accepts the current connection.

The PostgreSQL pg_backend_pid() function returns the process ID of the server process to which the current session is connected.

The PostgreSQL pg_blocking_pids() function returns a list of process IDs of sessions that prevent the specified session from acquiring locks.

The PostgreSQL pg_conf_load_time() function returns the last time the server configuration file was loaded (with timezone information).

The PostgreSQL pg_current_logfile() function returns the currently used log file path.

The PostgreSQL pg_is_other_temp_schema() function checks whether the specified OID is the OID of another session’s temporary schema.

The PostgreSQL pg_jit_available() function checks if the JIT compiler extension is available.

The PostgreSQL pg_listening_channels() function returns the name of the asynchronous notification channel the current session is listening on.

The PostgreSQL pg_my_temp_schema() function returns the OID of the temporary schema for the current session.

The PostgreSQL pg_notification_queue_usage() function returns the maximum size portion of the asynchronous notification queue currently occupied by unprocessed notifications.

The PostgreSQL pg_postmaster_start_time() function returns the time the server was started.

The PostgreSQL pg_trigger_depth() function returns the current nesting level of triggers.

The PostgreSQL user returns the name of the current user (the user of the current execution context).

The PostgreSQL version() function returns the version of the current PostgreSQL server.