Remove database name in PROMPT1 for psql

Now the only thing added is if current user if a superuser or not. This
is useful for debugging and copy-paste of results somewhere without having
user-related information revealed.