| From: | Ed Stoner <ed(at)whsd(dot)k12(dot)pa(dot)us> |
|---|---|
| To: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Numeric user names |
| Date: | 2004-10-19 13:20:45 |
| Message-ID: | 417514AD.50801@whsd.k12.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 2004-10-19 13:20:55 | Re: Another list for windows port... |
| Previous Message | Markus Schaber | 2004-10-19 12:10:15 | Re: Avoiding explicit addDataType calls for PostGIS |