Editable Views
Editable Views
Using PostgreSQL 9.3 on Linux Red-Hat platform. Does PostgreSQL allow editable views? Thanks in advance. df
Re: Editable Views
От:
Matheus de Oliveira <matioli.matheus@gmail.com>
Дата:
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.
[1] http://www.postgresql.org/docs/current/static/sql-createview.html#SQL-CREATEVIEW-UPDATABLE-VIEWS
Regards,
--
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres
Re: Editable Views
Thank you for the info. -----Original Message----- From: Matheus de Oliveira [mailto:matioli.matheus@gmail.com] Sent: Friday, July 18, 2014 3:22 PM To: Ferrell, Denise CTR NSWCDD, Z11 Cc: pgsql-admin@postgresql.org; Forums postgresql Subject: Re: [ADMIN] Editable Views On Fri, Jul 18, 2014 at 1:56 PM, Ferrell, Denise CTR NSWCDD, Z11 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. [1] http://www.postgresql.org/docs/current/static/sql-createview.html#SQL-CREATEVIEW-UPDATABLE-VIEWS Regards, -- Matheus de Oliveira Analista de Banco de Dados Dextra Sistemas - MPS.Br nível F! www.dextra.com.br/postgres
Re: Editable Views
От:
Thangavel D Duraisamy <than.gold@gmail.com>
Дата:
Pls remove meeeeeee..... On 7/19/14, Ferrell, Denise CTR NSWCDD, Z11 wrote: > Thank you for the info. > > -----Original Message----- > From: Matheus de Oliveira [mailto:matioli.matheus@gmail.com] > Sent: Friday, July 18, 2014 3:22 PM > To: Ferrell, Denise CTR NSWCDD, Z11 > Cc: pgsql-admin@postgresql.org; Forums postgresql > Subject: Re: [ADMIN] Editable Views > > > On Fri, Jul 18, 2014 at 1:56 PM, Ferrell, Denise CTR NSWCDD, Z11 > 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. > > > [1] > http://www.postgresql.org/docs/current/static/sql-createview.html#SQL-CREATEVIEW-UPDATABLE-VIEWS > > > Regards, > > -- > Matheus de Oliveira > Analista de Banco de Dados > Dextra Sistemas - MPS.Br nível F! > www.dextra.com.br/postgres > > > -- Gold