Postgres Pro
Downloads
Home   >   mailing lists

Re: manipuliation the pg_shadow table - Mailing list pgsql-general

From Tom Lane
Subject Re: manipuliation the pg_shadow table
Date
Msg-id 2232.1037398452@sss.pgh.pa.us
Whole thread Raw
In response to manipuliation the pg_shadow table  ("Bob Powell" <Bob@hotchkiss.org>)
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Installing PostgreSQL on HPUX 11i (with TCL) -- how does one do it
Next
From: Tom Lane
Date:
Subject: Re: Error in SELECT clause with UPPER function