I've created a backend api that connects to
postgres and performs various queries.
I've created a specific user (role + can login privilege) for that backend api:
I've also dropped the public schema in favor of a new one to be used by a backend api:
In order to avoid having to prefix each query made by the backend api, I changed the search path like below:
ALTER ROLE backend_api_user SET search_path TO apischema;
Problem is that I need to prefix references to tables in the backend api queries. So something is not working even if it looks okay from postgres'perspective:
SELECT usename, useconfig FROM pg_user WHERE usename='backend_api_user'
Side note: I'm using postgres and pgadmin4. Both are docker containers that I run using docker desktop for mac.
Thank you so much.