2011/3/14 Stefan Gündhör <stefan@xxxxxxxxxxxxx>: > Hi, > If I have following tables for example: > # Main Table: > id(id/pk) | geometry > --------------------------- > 1 | ... > # Additional Attribute Table: > name(id/pk) | value > --------------------------- > date_added | 20.12.1988 > name | Vienna > # m:n table: > mainTableID | attrTableID > ----------------------------------- > 1 | date_added > 1 | name > And i would like to automatically generate a View like > the following: > id(id/pk) | geometry | date_added | name > ----------------------------------------------------------- > 1 | ... | 20.12.1988 | Vienna > This example is a simplified (and not really functional) version of what I > would like to do - > but it should make clear what I have in view: Dynamically generating a > View's columns depending on the rows of a table. > Does anybody know, if this is possible? > Thank you for your replies in advance, > best regards, > Stefan Gündhör The columns in a view are strictly defined when you 'create view'. However, nothing is stopping you from implementing triggers that EXECUTE 'create view' from a plpgsql function if that's what you'd like to do, as long as you are willing to deal with the headaches surrounding that approach. ISTM though that there is probably a simpler solution to your problem though than manipulating view definitions. merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
