Обсуждение: New Column existing table + View

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