* Florian G. Pflug (fgp(at)phlo(dot)org) wrote:
> 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.
Alright, can you describe *exactly* what you'd want to see then? Is
this a new command-line option to psql (perhaps something like -v?)? Or
do you need it to be supported by libpq through a new connect-string
option (for, say, ODBC, or DBD/DBI in perl, etc.)? Both?
A generic "set this SQL variable after connecting" might not be a bad
option for psql to have. I know I'd like to see something like that for
pg_dump and pg_restore so I can "set role" before dumping or restoring.
Thanks,
Stephen