Thread: manipuliation the pg_shadow table

manipuliation the pg_shadow table

From
"Bob Powell"
Date:
Hi everyone,

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.

Bob Powell



Re: manipuliation the pg_shadow table

From
Tom Lane
Date:
"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