Re: Cannot query views with WHERE clause on renamed columns

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alexander Reichstadt <lxr(at)mac(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Cannot query views with WHERE clause on renamed columns
Date: 2014-06-30 22:59:56
Message-ID: 24334.1404169196@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alexander Reichstadt <lxr(at)mac(dot)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 any qualifier 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message frank ernest 2014-06-30 23:58:06 how to create multiple databases running in different dirs
Previous Message David G Johnston 2014-06-30 22:59:24 Re: Cannot query views with WHERE clause on renamed columns