how to give access to another user to see your postgresql code example
Example: how to give access to database in postgresql server to another user
GRANT permissions ON DATABASE dbname TO username;
GRANT permissions ON DATABASE dbname TO username;