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: | Raw Message | Whole Thread | 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 |