how to change postgresql password if my username contains period

Question

I want to change my pg/sql pwd using the syntax

alter user username WITH PASSWORD '*****';

The problem is that my user name contains a period, like user.name, and it seems the system doesn't allow a period in user name.

So how can I change my password?

Answer 1

You have to double-quote otherwise illegal identifiers. More in the manual.

ALTER USER "a.b" WITH PASSWORD '*****';

Better yet: never use illegal strings to begin with.