1 year, 5 months ago Sergei Golubchik

No and SQL Standard does not allow to SET more than one role.

A workaround for you would be to create a role, say, "my_default_role", make it default, and grant all other roles not to you directly, but to this role. It'll work exactly as you want — all roles assigned to "my_default_role" will be immediately available to you.