Re: Numeric user names - Mailing list pgsql-general

From Ed Stoner
Subject Re: Numeric user names
Date
Msg-id 417514AD.50801@whsd.k12.pa.us
Whole thread Raw
In response to Re: Numeric user names  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-general
Thanks.  This worked.  This is exactly what I was looking for.

Stephan Szabo wrote:
> On Tue, 12 Oct 2004, Ed Stoner wrote:
>
>
>>I am unable to use the "CREATE USER" command with numeric user names
>>(i.e. CREATE USER 35236 WITH PASSWORD '1234';).  Is this a limitation or
>>a problem somewhere with how I have things configured?  Is there are
>>workaround?
>
>
> I believe you can create a user with a quoted identifier that is all
> numbers (ie CREATE USER "35236") but then you have to quote the username
> for sql statements like grant and revoke as well.

pgsql-general by date:

Previous
From: Ed Stoner
Date:
Subject: Re: Numeric user names
Next
From: Eric E
Date:
Subject: Sequence question