Postgres Pro
Downloads
Home   >   mailing lists

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

From Josh Berkus
Subject Re: dropping users that start with ';'
Date
Msg-id 200310071349.16764.josh@agliodbs.com
Whole thread Raw
In response to dropping users that start with ';'  ("Gatts" <gatts27@mailforce.net>)
List pgsql-novice
Tree view 
Gatta,

> By mistake I created a pgsql user whose username begins with a ;

I won't ask.

> I am now having trouble dropping the user:
>
> dropuser ;trialuser

Do it in the PSQL terminal, and quote the user name:

DROP USER ";trialuser";


--
-Josh Berkus
 Aglio Database Solutions
 San Francisco

pgsql-novice by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Trigger return value
Next
From: Oliver Elphick
Date:
Subject: Re: perlsub