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

Renaming the directory in the data directory doesn't
work either.



--- Bruce Momjian <pgman@candle.pha.pa.us> wrote:
> > 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
>
> ************
>


=====
Thanks.
Soundar.
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com