pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed[ADMIN] Editable Views
6+ messages / 5 participants
[nested] [flat]
* [ADMIN] Editable Views
@ 2014-07-18 16:56 Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>
0 siblings, 2 replies; 6+ messages in thread
From: Ferrell, Denise CTR NSWCDD, Z11 @ 2014-07-18 16:56 UTC (permalink / raw)
To: pgsql-admin; Forums postgresql <pgsql-general@postgresql.org>
Using PostgreSQL 9.3 on Linux Red-Hat platform.
Does PostgreSQL allow editable views?
Thanks in advance.
df
Attachments:
smime.p7s (application/pkcs7-signature, 5.5K) download
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [ADMIN] Editable Views
@ 2014-07-18 17:19 David G Johnston <david.g.johnston@gmail.com>
parent: Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>
1 sibling, 0 replies; 6+ messages in thread
From: David G Johnston @ 2014-07-18 17:19 UTC (permalink / raw)
To: pgsql-general@postgresql.org
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.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [ADMIN] Editable Views
@ 2014-07-18 19:21 Matheus de Oliveira <matioli.matheus@gmail.com>
parent: Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>
1 sibling, 1 reply; 6+ messages in thread
From: Matheus de Oliveira @ 2014-07-18 19:21 UTC (permalink / raw)
To: Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>; +Cc: pgsql-admin; Forums postgresql <pgsql-general@postgresql.org>
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [ADMIN] Editable Views
@ 2014-07-18 19:25 Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>
parent: Matheus de Oliveira <matioli.matheus@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Ferrell, Denise CTR NSWCDD, Z11 @ 2014-07-18 19:25 UTC (permalink / raw)
To: Matheus de Oliveira <matioli.matheus@gmail.com>; +Cc: pgsql-admin; Forums postgresql <pgsql-general@postgresql.org>
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/;
Attachments:
smime.p7s (application/pkcs7-signature, 5.5K) download
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [ADMIN] Editable Views
@ 2014-07-19 00:39 Thangavel D Duraisamy <than.gold@gmail.com>
parent: Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>
0 siblings, 1 reply; 6+ messages in thread
From: Thangavel D Duraisamy @ 2014-07-19 00:39 UTC (permalink / raw)
To: Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>; +Cc: Matheus de Oliveira <matioli.matheus@gmail.com>; pgsql-admin; Forums postgresql <pgsql-general@postgresql.org>
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [GENERAL] Editable Views
@ 2014-07-19 00:58 Adrian Klaver <adrian.klaver@aklaver.com>
parent: Thangavel D Duraisamy <than.gold@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Adrian Klaver @ 2014-07-19 00:58 UTC (permalink / raw)
To: Thangavel D Duraisamy <than.gold@gmail.com>; Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>; +Cc: Matheus de Oliveira <matioli.matheus@gmail.com>; pgsql-admin; Forums postgresql <pgsql-general@postgresql.org>
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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2014-07-19 00:58 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-07-18 16:56 [ADMIN] Editable Views Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>
2014-07-18 17:19 ` David G Johnston <david.g.johnston@gmail.com>
2014-07-18 19:21 ` Matheus de Oliveira <matioli.matheus@gmail.com>
2014-07-18 19:25 ` Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>
2014-07-19 00:39 ` Thangavel D Duraisamy <than.gold@gmail.com>
2014-07-19 00:58 ` Adrian Klaver <adrian.klaver@aklaver.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox