[EMAIL PROTECTED] writes: > alter user Test with password 'testpwd'; You need double quotes.
alter user "Test" with password 'testpwd';
You may care to read the section of the user's guide that discusses
case insensitivity of identifiers in SQL.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
