Is there a way to configure PostgreSQL to create a database whose name is the same as the username on the user's first login?
pg_hba.conf there will be a rule something like:
local sameuser all ident sameuser
When a user connects to PostgreSQL via console/psql,
- If a database with the users name exists, just connect to database.
- If it does not exist, create a database named after the user and connect the user to the newly created database.
There are a lot of users and I do not want to manually create these databases all at once, upfront.