Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com> writes:
> ON instead of second ALTER looks better, and IMHO DATABASE <dbname> should
> be optional too:
> ALTER ROLE <rolename> [ON DATABASE <dbname>] SET <config> TO <value>;
IN, not ON.
regards, tom lane