Re: Numeric user names

Поиск
Список
Период
Сортировка
Искать
От
Stephan Szabo
Тема
Re: Numeric user names
Дата
Msg-id
20041018230038.L42271@megazone.bigpanda.com
Ответ на
Numeric user names (Ed Stoner)
Список
Дерево обсуждения
Numeric user names Ed Stoner <ed@whsd.k12.pa.us>
Re: Numeric user names Neil Conway <neilc@samurai.com>
Re: Numeric user names Tom Lane <tgl@sss.pgh.pa.us>
Re: Numeric user names Ed Stoner <ed@whsd.k12.pa.us>
Re: Numeric user names Lincoln Yeoh <lyeoh@pop.jaring.my>
Re: Numeric user names Stephan Szabo <sszabo@megazone.bigpanda.com>
Re: Numeric user names Ed Stoner <ed@whsd.k12.pa.us>

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.
В списке pgsql-general по дате отправления
От: Thomas F.O'Connell
Дата:
Сообщение: Re: vacuum schema
От: Tom Lane
Дата:
Сообщение: Re: Numeric user names
FAQ