Possible FAQs: single-quote and rename database

Nathan L. Cutler <livingston@iol.cz>

From: "Nathan L. Cutler" <livingston@iol.cz>
To: pgsql-general@postgresql.org
Date: 1999-12-23T06:41:07Z
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