"Bob Powell" <Bob(at)hotchkiss(dot)org> writes:
> Can anyone tell me if it is a problem to use the update command to change colunm values in the pg_shadow table?
> UPDATE pg_shadow SET usesuper = 't' where usename = 'bob'
> makes bob a superuser. Is this kind of thing OK? Thanks.
You can get away with it, but it's probably better to use ALTER USER.
regards, tom lane