Unable to delete user with special character

0

Hi there,
I have some users in my database with special characters which can't be deleted, any idea how could I do it?

dwh_sch=# select * from pg_user where usename like 'jenn%' ;
usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil | useconfig
--------------------------------------------------------------------------------+-----------
jenni.tulamito | 125 | f | f | f | ******** | |
(1 row)

dwh_sch=# drop user jenni.tulamito ;
ERROR: syntax error at or near "."
LINE 1: drop user jenni.tulamito ;

Thanks

asked 4 years ago354 views
1 Answer
0
Accepted Answer

Wrap the username in double quotes.

CREATE USER "test.user" PASSWORD 'Testing123';
-- CREATE USER

select * from pg_user where usename like 'test%';
--   usename  | usesysid | usecreatedb | usesuper | usecatupd |  passwd  | valuntil | useconfig
-- -----------+----------+-------------+----------+-----------+----------+----------+-----------
--  test.user |      121 | f           | f        | f         | ******** |          |
DROP USER "test.user";
-- DROP USER
 
select * from pg_user where usename like 'test%';
--  usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil | useconfig
-- ---------+----------+-------------+----------+-----------+--------+----------+----------- 
answered 4 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions