Ben Uphoff <buphoff@xxxxxxxxxxxxx> writes: > 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 > ? Because the SQL standard says we should. There's explicit text in there to the effect that adding columns to the underlying table does not add columns to the view. Which, I'm sure, is exactly what you wished would happen ... but they say not to. regards, tom lane
