1 Answer
- Newest
- Most votes
- Most comments
0
【以下的回答经过翻译处理】 将用户名带上双引号即可,示例如下
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
-- ---------+----------+-------------+----------+-----------+--------+----------+-----------
Relevant content
- asked a year ago
- asked a year ago
- Accepted Answerasked 10 months ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 5 months ago