Skip to main content
Skip to main content

SET Statement

SET param = value

Assigns value to the param setting for the current session. You cannot change server settings this way.

You can also set all the values from the specified settings profile in a single query.

SET profile = 'profile-name-from-the-settings-file'

For boolean settings set to true, you can use a shorthand syntax by omitting the value assignment. When only the setting name is specified, it is automatically set to 1 (true).

-- These are equivalent:
SET force_index_by_date = 1
SET force_index_by_date

For more information, see Settings.