Re: New Column existing table + View - Mailing list pgsql-admin

From Gunnar \"Nick\" Bluth
Subject Re: New Column existing table + View
Date
Msg-id 568F7E83.40002@elster.de
Whole thread Raw
In response to New Column existing table + View  ("drum.lucas@gmail.com" <drum.lucas@gmail.com>)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: "drum.lucas@gmail.com"
Date:
Subject: New Column existing table + View
Next
From: Edgar Delgado
Date:
Subject: Partitioned Tables vs Vacuum+Reindex