Re: [SQL] Dropping users with no name

2001-04-14 Thread Oliver Elphick
=?iso-8859-1?Q?Hans=2DJ=FCrgen=20Sch=F6nig?= wrote: >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 | use

[SQL] Dropping users with no name

2001-04-13 Thread Hans-Jürgen Schönig
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 --+--+-+--+