Re: Valid characters for user/role/group names?

Поиск
Список
Период
Сортировка
От Sam Mason
Тема Re: Valid characters for user/role/group names?
Дата
Msg-id 20090225165848.GV32672@frubble.xen.chris-lamb.co.uk
обсуждение исходный текст
Ответ на Valid characters for user/role/group names?  ("Roderick A. Anderson" <raanders@cyber-office.net>)
Ответы Re: Valid characters for user/role/group names?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Wed, Feb 25, 2009 at 08:50:15AM -0800, Roderick A. Anderson wrote:
> http://www.postgresql.org/docs/current/interactive/sql-syntax-lexical.html
>
> "SQL identifiers and key words must begin with a letter (a-z, but also
> letters with diacritical marks and non-Latin letters) or an underscore
> (_). Subsequent characters in an identifier or key word can be letters,
> underscores, digits (0-9), or dollar signs ($). Note that dollar signs
> are not allowed in identifiers according to the letter of the SQL
> standard, so their use might render applications less portable. ... "

You'd want to put double quotes around the identifier.  Try searching
for "quoted identifier" in the above page.

--
  Sam  http://samason.me.uk/

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

Предыдущее
От: "Roderick A. Anderson"
Дата:
Сообщение: Valid characters for user/role/group names?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Valid characters for user/role/group names?