New Column existing table + View

From: "drum(dot)lucas(at)gmail(dot)com" <drum(dot)lucas(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: New Column existing table + View
Date: 2016-01-07 22:43:31
Message-ID: CAE_gQfX5E0Xh7xVdqH_AoX5OJuewsPkHwutkZ+OMZRDff00XPA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gunnar "Nick" Bluth 2016-01-08 09:16:51 Re: New Column existing table + View
Previous Message Federico Campoli 2016-01-07 10:26:16 Re: pglogical bug report