Csanyi Pal <csanyipal(at)gmail(dot)com> writes:
> When in phpPgAdmin I can't modify the existing view.
> I get the message:
> ERROR: cannot change name of view column "az els nap" to "els nap"
> Why can't I modify the view when in phpPgAdmin?
I don't think this has anything to do with phpPgAdmin; it's a safety
check built into CREATE OR REPLACE VIEW.
Try using ALTER TABLE viewname RENAME COLUMN x TO y;
(Not sure why ALTER VIEW doesn't have this variant, but that's
just a cosmetic detail. ALTER TABLE will work.)
regards, tom lane