Re: [GENERAL] Possible FAQs: single-quote and rename database

> 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 "'"

INSERT INTO bubba VALUES ('\'');

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

I think you can modify pg_database with new name, stop postmaster,
rename database directory, and restart.  Not sure, but that may work.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026