Re: views are not auto completed on psql

On Fri, 24 May 2002 17:16:28 -0700
"Jeff Post" <postjeff(at)uwm(dot)edu> wrote:

> The best way that I can think to describe this is that views are not added
> as candidates of possible line completions in psql.
> So if I have a view with the name org_details and a table with the name
> organizations and I try select * from org<TAB> the completion is
> organizations not a list of organizations and org_details.

On my end, that doesn't seem to be the case (running a build of CVS
that is few days old):

nconway=> create table organizations (a int);
CREATE TABLE
nconway=> create view org_details as select * from organizations;
CREATE VIEW
nconway=> select * from org<TAB>
org_details organizations

(where <TAB> represents hitting the tab key a couple times)

The query issued by psql is:

SELECT relname FROM pg_class WHERE (relkind='r' or relkind='v') and substr(relname,1,3)='org'

... which suggests to me that, at least for the common case, views are
supported for line completion.

Can you give us a reproducible test-case that demonstrates the problem?

Cheers,

Neil

--
Neil Conway <neilconway(at)rogers(dot)com>
PGP Key ID: DB3C29FC