Re: quoting psql varible as identifier - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: quoting psql varible as identifier
Date
Msg-id 162867790912291155y340ac8cfg7523081217947e72@mail.gmail.com
Whole thread Raw
In response to Re: quoting psql varible as identifier  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
2009/12/29 Alvaro Herrera <alvherre@commandprompt.com>:
> Pavel Stehule escribió:
>> 2009/12/29 Alvaro Herrera <alvherre@commandprompt.com>:
>> > Pavel Stehule escribió:
>> >> 2009/12/29 Tom Lane <tgl@sss.pgh.pa.us>:
>> >> > Pavel Stehule <pavel.stehule@gmail.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
>


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: quoting psql varible as identifier
Next
From: Tom Lane
Date:
Subject: Re: quoting psql varible as identifier