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. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html