Using database schema for multiple Projeqtor instances in one PostgreSQL database

With a PostgreSQL database, one can create multiple database schemas.
Ref Doc

Use case :

• on a given PostGreSQL server, (IP@, Port)

• each Programme (i.e. MegaProject) is a database.

• which contains several (ProjQtor) projects.

Schemas would give somes facilities to database administration (backup, access rights, ...)


When accessing tables, you just prefix the database with the Schema name.
I have tried to use the "table prefix" with a name like 'myProject.' (note the '.' dot ). but with no success.
I got a bunch of errors on database creation...
Guess the '.) (dot) character is not welcome in the "table prefix" parameter ?

A workaround is to use different database (PostgreSQL) users (roles), and to define the right schema as the default schema
as in