Re: quoting psql varible as identifier

Pavel Stehule escribió:
> 2009/12/29 Alvaro Herrera <alvherre(at)commandprompt(dot)com>:
> > Pavel Stehule escribió:
> >> 2009/12/29 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> >> > Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> writes:
> >> >> so we cannot simply implement quote_ident on client side :(. So we
> >> >> have to use a real query.
> >> >
> >> >> It is acceptable for you?
> >> >
> >> > No, certainly not --- that adds a boatload of failure conditions.
> >> > Just quote it unconditionally.
> >>
> >> ok
> >>
> >> this function have to live in libpq - it needs some not exported
> >> functionality. But, it would not be a problem.
> >
> > Can we use a trick similar to pg_dump's?
>
> ??

See src/bin/pg_dump/keywords.c and fmtId in dumputils.c

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support