Re: Numeric user names

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Ed Stoner <ed(at)whsd(dot)k12(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Numeric user names
Date: 2004-10-19 06:02:21
Message-ID: 20041018230038.L42271@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-10-19 06:33:08 Re: Numeric user names
Previous Message Thomas F.O'Connell 2004-10-19 05:48:34 Re: vacuum schema