Re: Cannot query views with WHERE clause on renamed columns - Mailing list pgsql-general

From Tom Lane
Subject Re: Cannot query views with WHERE clause on renamed columns
Date
Msg-id 24334.1404169196@sss.pgh.pa.us
Whole thread Raw
In response to Cannot query views with WHERE clause on renamed columns  (Alexander Reichstadt <lxr@mac.com>)
List pgsql-general
Alexander Reichstadt <lxr@mac.com> writes:
> I try to do what seems to be totally simple, but it fails. If I query a view that contains renamed columns without
anyqualifier like 

> SELECT * FROM myview

> it displays everything. If however I do

> SELECT reanmedviewcolumn FROM myview

> It tells me column does not exist which in fact does.

What do you mean by a "renamed column"?  A concrete example would help
here.

            regards, tom lane


pgsql-general by date:

Previous
From: David G Johnston
Date:
Subject: Re: Cannot query views with WHERE clause on renamed columns
Next
From: "frank ernest"
Date:
Subject: how to create multiple databases running in different dirs