New to the cloud SQL service, so create a postgres 12.4 database and created a user with admin rights. But cannot use the 'create schema...' command - get permission denied.
beepaid_db=> CREATE SCHEMA myschema2;
ERROR: permission denied for database beepaid_db
Could someone else please verify this command does not work on their postgres database.
Or have I setup so,mething wrong here. The reason why schemas are important to me is I use django-tenants - and this in turn makes use of this postgres feature.
Have a ticketr open with OVH support - after one week still awaiting a formal response on this - hence reaching out to community to see if there is a workaround/solution.
Many thanks in advance - dave