How it works…

You can set parameters for each of the following:

• Database
• User (which is named role by PostgreSQL)
• Database/user combination

Each of the parameter defaults is overridden by the one following it.

In the preceding three SQL statements:

• If user hannu connects to the saas database, then value1 will apply
• If user simon connects to a database other than saas, then value2 will apply
• If user simon connects to the saas database, then value3 will apply

PostgreSQL implements this in exactly the same way as if the user had manually issued the equivalent SET statements immediately after connecting.