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 <neilc@samurai.com> 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