On Fri, 24 May 2002 17:16:28 -0700
"Jeff Post" <postjeff@uwm.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@rogers.com>
PGP Key ID: DB3C29FC