Horton

Re: [HACKERS] Autocomplete <TAB> on Postgres7.4beta5 not working?

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Rod Taylor <rbt@rbt.ca>
Cc: Alvaro Herrera Munoz <alvherre@dcc.uchile.cl>, Gaetano Mendola <mendola@bigfoot.com>, pgsql-bugs@postgresql.org, PostgreSQL Development <pgsql-hackers@postgresql.org>, Ian Barwick <barwick@gmx.net>
Date: 2003-10-28T23:49:28Z
Lists: pgsql-bugs, pgsql-hackers 
Rod Taylor <rbt@rbt.ca> writes:
> I say leave it the way it is. If you want system table tab completion,
> simply:
>         ALTER USER ... SET search_path =3D pg_catalog,...;

Unfortunately, that *does not* affect the tab-completion behavior;
it will still not offer the system catalogs as completions unless
you explicitly prefix "pg_catalog.".

			regards, tom lane