Re: 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(dot)wenk(at)netzmeister-st-pauli(dot)de]
Sent: Friday, July 17, 2009 8:18 AM
To: Campbell, Lance
Cc: pgsql-admin(at)postgresql(dot)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(at)postgresql(dot)org

Cheers

Andy

On Fri, Jul 17, 2009 at 11:34 AM, Campbell, Lance<lance(at)illinois(dot)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(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate