Thread: New Column existing table + View
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?
VARCHAR(255) or TEXT
nullable
and CRUDs on the view to apply to the table
Thanks
Am 07.01.2016 um 23:43 schrieb drum.lucas@gmail.com: > 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