PostgreSQL view

From gnewarchaeology wiki
Revision as of 10:53, 25 January 2016 by Dncgst (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
PostgreSQL > PostgreSQL view

Create views with the geom column

  • []

create view view_lithic_tool as select record, lithic_class, lithic_object, typo, blank, tool, retouch, comment from lithic where lithic_object = 'tool';

Update views

  • []

create rule lithic_upd as on update to view_lithic_tool do instead update lithic set lithic_class = NEW.lithic_class where record = NEW.record;