Re: [GENERAL] Numeric user names

[Ed Stoner]

I want to use bare numbers because that is how the users (students in 
this case) are identified on the network and in the student information 
system.  They've been identified this way for over 20 years, so it would 
be near impossible to change at this point (although it is not always 
very convenient :-).  I'm trying (and almost finished now) to have the 
postgres server be the source of all user account information on the 
network (windows and linux).

-Ed
Tom Lane wrote:
Neil Conway <[EMAIL PROTECTED]> writes:
I don't know of an easy workaround. Why do you need numeric usernames?

There's always double-quoted identifiers:
        create user "12345" with password ...
Considering that the SQL standard defines <authorization identifier>
as an <identifier>, I'm not sure why Ed is expecting that he should
be able to use a bare number as a user name.
			regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings