Dropping users with no name
| От | Hans-Jürgen Schönig |
|---|---|
| Тема | Dropping users with no name |
| Дата | |
| Msg-id | 3AD48650.E18D0615@cybertec.at обсуждение исходный текст |
| Ответы |
Re: Dropping users with no name
|
| Список | pgsql-sql |
I have accidentally created a user with no name. How can I delete this user? I have compiled my attempts below: Hans persons=# SELECT * FROM pg_user;usename | usesysid | usecreatedb | usetrace | usesuper | usecatupd | passwd | valuntil ----------+----------+-------------+----------+----------+-----------+----------+---------- postgres | 26 | t | t | t | t | ******** | | 27 | f | f | f | f | ******** | (2 rows) persons=# DELETE FROM pg_user where usesysid>26; DELETE 0 persons=# SELECT '$'|| usename||'$' FROM pg_user; ?column? ------------$postgres$$$ (2 rows) persons=# DROP USER ''; ERROR: parser: parse error at or near "'"
В списке pgsql-sql по дате отправления: