manipuliation the pg_shadow table

"Bob Powell" <Bob@hotchkiss.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