* Florian G. Pflug (fgp@xxxxxxxx) 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
Attachment:
signature.asc
Description: Digital signature
