"Graham Vickrage" <graham(at)gpmd(dot)co(dot)uk> writes:
> I want to keep all the privileges but assign them to a new user.
> What is the best way of doing this?
How about just renaming the old user to a new name?
I don't think we have an ALTER command for that, but an UPDATE on
pg_shadow would get the job done just as well.
regards, tom lane