Re: quoting psql varible as identifier
Alvaro Herrera <alvherre@commandprompt.com>
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>, Robert Haas <robertmhaas@gmail.com>
Date: 2009-12-29T19:52:18Z
Lists: 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