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