From: | Ben Uphoff <buphoff(at)villagemd(dot)com> |
---|---|
To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Saving view turns SELECT * into field list |
Date: | 2018-10-15 19:50:05 |
Message-ID: | 4748E0E4-9D2A-4D44-B20F-6749E8C989D7@villagemd.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hey team – I’m sure this has come up, but my search engine skills couldn’t find an explanation:
Why, when I save a simple view like:
SELECT * FROM a_table
…does PostgreSQL turn the * into a field list like:
SELECT field1, field2, field3, field4 FROM a_table
?
This is super-frustrating, as it means I’ll have to manually change an aggregating “parent” view’s select lists every time I change the “child” views.
Thanks for any info. -Ben
******************* PLEASE NOTE ******************* This E-Mail/telefax message and any documents accompanying this transmission may contain information that is privileged, confidential, and/or exempt from disclosure under applicable law and is intended solely for the addressee(s) named above. If you are not the intended addressee/recipient, you are hereby notified that any use of, disclosure, copying, distribution, or reliance on the contents of this E-Mail/telefax information is strictly prohibited and may result in legal action against you. Please reply to the sender advising of the error in transmission and immediately delete/destroy the message and any accompanying documents. Thank you.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2018-10-15 19:55:11 | Re: Saving view turns SELECT * into field list |
Previous Message | David Steele | 2018-10-15 17:56:41 | Re: Setting up continuous archiving |