Enhancement - code completion when typing set search_path

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