PostgreSQL 11 Administration Cookbook

How to do it…

Follow these steps to set parameters at various levels as per the requirements:

1. For all users in the saas database, use the following commands:

ALTER DATABASE saasSET configuration_parameter = value1;

2. For a user named simon connected to any database, use the following commands:

ALTER ROLE simonSET configuration_parameter = value2;

3. Alternatively, you can set a parameter for a user only when they're connected to a specific database, as follows:

ALTER ROLE simonIN DATABASE saasSET configuration_parameter = value3;

The user won't know that these have been executed specifically for them. These are default settings, and in most cases they can be overridden if the user requires non-default values.