Home > mailing lists

Re: Editable Views - Mailing list pgsql-admin

From	Matheus de Oliveira
Subject	Re: Editable Views
Date	July 18, 2014 22:22:14
Msg-id	CAJghg4JHTppsfwpkWNdrGcS6TLtzkB+Ux0xD8H61P7p50_TW5g@mail.gmail.com Whole thread Raw
In response to	Editable Views ("Ferrell, Denise CTR NSWCDD, Z11" <denise.ferrell.ctr@navy.mil>)
Responses	Re: Editable Views ("Ferrell, Denise CTR NSWCDD, Z11" <denise.ferrell.ctr@navy.mil>)
List	pgsql-admin

On Fri, Jul 18, 2014 at 1:56 PM, Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil> wrote:

Using PostgreSQL 9.3 on Linux Red-Hat platform.

Does PostgreSQL allow editable views?

Yes, it has automatically updatable views since 9.3, see [1].

You can also add a trigger or a rule to make it updatable.

Regards,

--
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres

From: "Ferrell, Denise CTR NSWCDD, Z11"
Date: 18 July 2014, 19:56:26
Subject: Editable Views

From: "Ferrell, Denise CTR NSWCDD, Z11"
Date: 18 July 2014, 22:26:39
Subject: Re: Editable Views