From: | "Gunnar \"Nick\" Bluth" <gunnar(dot)bluth(dot)extern(at)elster(dot)de> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: New Column existing table + View |
Date: | 2016-01-08 09:16:51 |
Message-ID: | 568F7E83.40002@elster.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Am 07.01.2016 um 23:43 schrieb drum(dot)lucas(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Edgar Delgado | 2016-01-08 14:30:59 | Partitioned Tables vs Vacuum+Reindex |
Previous Message | drum.lucas@gmail.com | 2016-01-07 22:43:31 | New Column existing table + View |