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.