Stephen Frost wrote:
* Florian G. Pflug ([EMAIL PROTECTED]) wrote:
I'd like to be able to connect to postgres, and automatically assume a
specific role.
Couldn't you just have 'SET ROLE <whatever>' in the user's .psqlrc? At
least, if that's how they're connecting I think that'd work...
I can do that with "alter user <user> set role <whatever>" too...
But I'd like my users to be able to connect as either role "dev" or
role "admin", depending on the task they want to do.
greetings, Florian Pflug
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
