Thread: [ADMIN] Editable Views
Using PostgreSQL 9.3 on Linux Red-Hat platform. Does PostgreSQL allow editable views? Thanks in advance. df
Ferrell, Denise CTR NSWCDD, Z11 wrote > Using PostgreSQL 9.3 on Linux Red-Hat platform. > > Does PostgreSQL allow editable views? Please do not cross-post, even within these mailing lists. In almost all cases it is sufficient to post to -general. And besides, this is not really a server administration question. Google: postgresql editable views 9.3 The short answer from the search is that you can as-of 9.1 While no official pages come up the bulk of the links do make reference to using triggers to update views. Looking then at the documentation for CREATE TRIGGER http://www.postgresql.org/docs/9.1/static/sql-createtrigger.html You will see that as of 9.1 INSTEAD OF triggers on views are possible. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/ADMIN-Editable-Views-tp5811973p5811982.html Sent from the PostgreSQL - general mailing list archive at Nabble.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
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 <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 <http://www.dextra.com.br/postgres/>
Attachment
Pls remove meeeeeee..... On 7/19/14, Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil> 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 > <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 <http://www.dextra.com.br/postgres/> > > > -- Gold
On 07/18/2014 05:39 PM, Thangavel D Duraisamy wrote: > Pls remove meeeeeee..... > See bottom of this email for link to unsubscribe. >> >> >> > > -- Adrian Klaver adrian.klaver@aklaver.com