Method Sql.pgsql()->getruntimeparameters()

Method getruntimeparameters

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.

Note

This function is PostgreSQL-specific, and thus it is not available through the generic SQL-interface.