Postgres Pro
Downloads
Home   >   mailing lists

Re: dropping users that start with ';' - Mailing list pgsql-novice

From Bruno LEVEQUE
Subject Re: dropping users that start with ';'
Date
Msg-id blv6c6$2tse$1@news.hub.org
Whole thread Raw
In response to dropping users that start with ';'  ("Gatts" <gatts27@mailforce.net>)
List pgsql-novice
Tree view 
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.leveque@net6d.com
http://www.net6d.com

pgsql-novice by date:

Previous
From: Oliver Fromme
Date:
Subject: Re: Foreign key error...
Next
From: "David Benoff"
Date:
Subject: Deleting blob data with LargeObject Java API