From: | "Nathan L(dot) Cutler" <livingston(at)iol(dot)cz> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Possible FAQs: single-quote and rename database |
Date: | 1999-12-23 06:41:07 |
Message-ID: | 19991223074107.A12201@iol.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Nikolay Mijaylov | 1999-12-23 08:22:33 | Re: [GENERAL] char(xx) problem |
Previous Message | Bruce Momjian | 1999-12-23 06:05:26 | Re: [GENERAL] shared memory - progress |