Pike v8.1 release 6

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

http://www.postgresql.org/search/?u=%2Fdocs%2Fcurrent%2F&q=client+connection+search_path

Note

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