On 2013-02-20 17:25:41 +0100, Misa Simic wrote: > Hi, > > If we want to "add new column" to the view - the only one way (we have > found) is: > > -drop view > -create it again ( with new column )
Since 8.4 you can add new columns to the end of a view definition using CREATE OR REPLACE VIEW. http://www.postgresql.org/docs/current/interactive/sql-createview.html : > CREATE OR REPLACE VIEW is similar, but if a view of the same name > already exists, it is replaced. The new query must generate the same > columns that were generated by the existing view query (that is, the > same column names in the same order and with the same data types), but > it may add additional columns to the end of the list. The calculations > giving rise to the output columns may be completely different. Btw, this is more of a pgsql-general type of question... Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers