Re: quoting psql varible as identifier

2009/12/29 Alvaro Herrera <alvherre(at)commandprompt(dot)com>:
> 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

I found it. It is maybe too complex for using in psql.

Pavel

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