Re: Something I don't understand with the use of schemas

On Mon, Dec 12, 2005 at 05:00:45PM -0500, Tom Lane wrote:
> "Jim C. Nasby" <jnasby@pervasive.com> writes:
> > I'd love to see something like SUDO ALTER USER ... SUDO REINDEX ... etc.
> > That would make it easy to do 'normal' work with a non-superuser
> > account.
> 
> You can already do most of this with SET/RESET ROLE:

Very cool, I didn't realize that. It would still be nice if there was a
way to do it on a per-command basis (since often you just need to run
one command as admin/dba/what-have-you), but I suspect adding that to
the grammar would be a real PITA. Perhapse it could be added to psql
though...
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461