Use the SET
command to change a runtime parameter.
Parameter or clause | Description |
---|---|
parameter_name | Name of the runtime parameters. |
value | New value of parameter. Values can be specified as string constants, identifiers, numbers, or comma-separated lists of these, as appropriate for the particular parameter. DEFAULT can be written to specify resetting the parameter to its default value (that is, whatever value it would have had if no SET had been executed in the current session). |
SET DATABASE TO
or USE
. Both commands allow you to change the current database without disconnecting and reconnecting.