Dropping users with no name

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 "'"

Browse pgsql-sql by date

  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