| From: | Hans-Jürgen Schönig <hs(at)cybertec(dot)at> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Dropping users with no name |
| Date: | 2001-04-11 16:29:04 |
| Message-ID: | 3AD48650.E18D0615@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 "'"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kovacs Zoltan | 2001-04-11 16:43:35 | Re: enumerating rows |
| Previous Message | Koen Antonissen | 2001-04-11 15:56:52 | RE: enumerating rows |