Re: All numeric database names?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: All numeric database names?
Дата
Msg-id 14709.1199829526@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: All numeric database names?  (Steve Crawford <scrawford@pinpointresearch.com>)
Список pgsql-admin
Steve Crawford <scrawford@pinpointresearch.com> writes:
> Alternately, you could prepend 1+ alpha characters to the customer
> numbers to create names like c123456 or cust123456 which don't need to
> be quote-enclosed.

I'd recommend that too.  Quite aside from the quoting problem, this
will save you tons of confusion if you ever have to deal with database
OIDs (during disaster recovery perhaps).

            regards, tom lane

В списке pgsql-admin по дате отправления:

Предыдущее
От: Steve Crawford
Дата:
Сообщение: Re: All numeric database names?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: -d option in pg_dump