Possible FAQs: single-quote and rename database

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

In response to

Responses

Browse pgsql-general by date

  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