Re: dropping users that start with ';'

From: Bruno LEVEQUE <bruno(dot)leveque(at)net6d(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: dropping users that start with ';'
Date: 2003-10-07 20:06:26
Message-ID: blv6c6$2tse$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Try
dropuser (return)
;trialuser (when dropuser asks : "Enter name of user to drop:")

Maybe you need to connect with an "authorized user". In this case use
dropuser -U user (return)

Bruno

Gatts wrote:

>By mistake I created a pgsql user whose username begins with a ;
>I am now having trouble dropping the user:
>
>dropuser ;trialuser
>ERROR: parser: parse error at or near "trialuser" at character 1
>ERROR: parser: parse error at or near "trialuser" at character 1
>
>can someone help?
>
>

--
Bruno LEVEQUE
System Engineer
SARL NET6D
bruno(dot)leveque(at)net6d(dot)com
http://www.net6d.com

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Berkus 2003-10-07 20:49:16 Re: dropping users that start with ';'
Previous Message Josh Berkus 2003-10-07 19:53:27 Re: Trigger return value