Re: Numeric user names

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: Numeric user names
Дата
Msg-id 20041018230038.L42271@megazone.bigpanda.com
обсуждение исходный текст
Ответ на Numeric user names  (Ed Stoner <ed@whsd.k12.pa.us>)
Ответы Re: Numeric user names
Список pgsql-general
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