Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.
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.
select * from mySchema.myTable;
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 ? :woohoo:
A workaround is to use different database (PostgreSQL) users (roles), and to define the right schema as the default schema
as in
ALTER USER user_name SET search_path to ...;