PostgreSQL 11 Administration Cookbook

How it works…

You can set parameters for each of the following:

• Database
• User (also called role by postgreSQL)
• Database and user combination

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

In the preceding three SQL statements, the following apply:

• If gianni connects to the saas database, then value1 will apply
• If simon connects to a database other than saas, then value2 will apply
• If 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.