Peter Eisentraut <peter_e@gmx.net> writes:
> The '>' is replaced by a '#' if you are the superuser. (Correction: if the
> username is "postgres". I'm still thinking about ways to make this a
> little more elegant though. Ideas welcome.)
You should be looking at the usesuper column from pg_user if you really
want a correct indication of whether the user has superuser privs.
regards, tom lane