Method Sql.pgsql()->getruntimeparameters()
- Method getruntimeparameters
final
mapping
(string
:string
) getruntimeparameters()- Returns
Currently active runtimeparameters for the open session; these are initialised by the options parameter during session creation, and then processed and returned by the server. Common values are:
"client_encoding"
:string
Character encoding for the client side, e.g.
"UTF8"
or"SQL_ASCII"
."server_encoding"
:string
Character encoding for the server side as determined when the database was created, e.g.
"UTF8"
or"SQL_ASCII"
."DateStyle"
:string
Date parsing/display, e.g.
"ISO, DMY"
."TimeZone"
:string
Default timezone used by the database, e.g.
"localtime"
."standard_conforming_strings"
:string
When on, backslashes in strings must not be escaped any longer.
"session_authorization"
:string
Displays the authorisationrole which the current session runs under.
"is_superuser"
:string
Indicates if the current authorisationrole has database-superuser privileges.
"integer_datetimes"
:string
Reports wether the database supports 64-bit-integer dates and times.
"server_version"
:string
Shows the server version, e.g.
"8.3.3"
.The values can be changed during a session using SET commands to the database. For other runtimeparameters check the PostgreSQL documentation.
- See also
https://www.postgresql.org/docs/current/static/runtime-config-client.html
- Note
This function is PostgreSQL-specific.