Re: Numeric user names

Поиск
Список
Период
Сортировка
От Ed Stoner
Тема Re: Numeric user names
Дата
Msg-id 417514AD.50801@whsd.k12.pa.us
обсуждение исходный текст
Ответ на Re: Numeric user names  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Список pgsql-general
Thanks.  This worked.  This is exactly what I was looking for.

Stephan Szabo wrote:
> 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 по дате отправления:

Предыдущее
От: Ed Stoner
Дата:
Сообщение: Re: Numeric user names
Следующее
От: Eric E
Дата:
Сообщение: Sequence question