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

From Alvaro Herrera
Subject Re: quoting psql varible as identifier
Date
Msg-id 20091229195218.GH4569@alvh.no-ip.org
Whole thread Raw
In response to Re: quoting psql varible as identifier  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: quoting psql varible as identifier  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
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

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


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: quoting psql varible as identifier
Next
From: Pavel Stehule
Date:
Subject: Re: quoting psql varible as identifier