Am 07.01.2016 um 23:43 schrieb drum.lucas@xxxxxxxxx: > Hi all! > > Question 1: > > I want to add a new column to a base table, and add that new column to > an existing view... > > So all selects/updates/deletes translate back to the original table > > How can I do that? 1a) ALTER TABLE 1b) CREATE OR REPLACE VIEW (assuming you have your initial CREATE VIEW statement still around, just add the additional column and add the "OR REPLACE") 1c) See http://michael.otacoo.com/postgresql-2/postgres-9-3-feature-highlight-auto-updatable-views/ if that fits your needs. Cheers, -- Gunnar "Nick" Bluth DBA ELSTER Tel: +49 911/991-4665 Mobil: +49 172/8853339 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
