Postgres Pro
Downloads
Home   >   mailing lists

manipuliation the pg_shadow table - Mailing list pgsql-general

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

pgsql-general by date:

Previous
From: karthickv@hclp.com (karthick v)
Date:
Subject: Output of function into a file
Next
From: "Andy Dunlop"
Date:
Subject: Postgres Support