=?ISO-8859-1?Q?St=E9phane_Schildknecht?= <stephane(dot)schildknecht(at)postgresqlfr(dot)org> writes:
> It seems the shell command createuser and the SQL CREATE USER don't act
> the same way,
They aren't really claimed to. But the difference you point to is
irrelevant, since a superuser has createrole and createdb privilege
(and every other privilege) independently of what those columns say.
regards, tom lane