Обсуждение: Enhancement - code completion when typing set search_path
I use postgres 8.1.X. Is there a way to add code completion when entering: set search_path = xyz I love the code completion for SQL. It would be really nice to have it for the "set search_path". Thanks, Lance Campbell Project Manager/Software Architect/DBA Web Services at Public Affairs 217-333-0382 -----Original Message----- From: Andreas Wenk [mailto:a.wenk@netzmeister-st-pauli.de] Sent: Friday, July 17, 2009 8:18 AM To: Campbell, Lance Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Enhancement - code completion when typing set search_path Campbell, Lance schrieb: > I use postgres 8.1.X. > > Is there a way to add code completion when entering: > > set search_path = xyz > > I love the code completion for SQL. It would be really nice to have > it for the "set search_path". me too ;-) you should send this request to the hackers list ... maybe it will be integrated in future versions ... pgsql-hackers@postgresql.org Cheers Andy
On Fri, Jul 17, 2009 at 11:34 AM, Campbell, Lance<lance@illinois.edu> wrote: > > I use postgres 8.1.X. > > Is there a way to add code completion when entering: > > set search_path = xyz > > I love the code completion for SQL. It would be really nice to have > it for the "set search_path". It sounds like a good idea to me; maybe you'd be interested it writing a patch to do it? ...Robert
On Fri, Jul 17, 2009 at 10:34:34AM -0500, Campbell, Lance wrote: > > I use postgres 8.1.X. > > Is there a way to add code completion when entering: > > set search_path = xyz > > I love the code completion for SQL. It would be really nice to have > it for the "set search_path". > > Thanks, You'll want to patch 8.5-to-be's psql, as we do not add new features into back-patches. Fortunately, 8.4 and up have backward-compatible psqls, so much of the infrastructure is already there :) Cheers, David. -- David Fetter <david@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate