Possible FAQs: single-quote and rename database

Поиск
Список
Период
Сортировка
От Nathan L. Cutler
Тема Possible FAQs: single-quote and rename database
Дата
Msg-id 19991223074107.A12201@iol.cz
обсуждение исходный текст
Ответ на Re: [GENERAL] char(xx) problem  (Gene Selkov <selkovjr@mcs.anl.gov>)
Ответы Re: [GENERAL] Possible FAQs: single-quote and rename database
Список pgsql-general
Hello:

I have two questions that might be FAQs (apologies in advance):

(1) Why does the parser choke on backslashed single-quote characters?  Or,
in other words, why doesn't this work:

testing=> \d bubba
Table    = bubba
+--------------------------+----------------------------------+-------+
|          Field           |              Type                | Length|
+--------------------------+----------------------------------+-------+
| litbub                   | varchar()                        | 60    |
+--------------------------+----------------------------------+-------+
testing=> insert '\'' into bubba;
ERROR:  parser: parse error at or near "'"

(2) How does one rename a database?  Other than dump/destroydb/restore,
obviously.

TIA

--
Nathan L. Cutler < livingston @ iol.cz >         telephone: +420-2-51611648
Livingston Professional Translations         fax:       +420-2-6514377
** When "pretty good" is not enough **           Prague, Czech Republic

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [GENERAL] shared memory - progress
Следующее
От: "Nikolay Mijaylov"
Дата:
Сообщение: Re: [GENERAL] char(xx) problem