PostgreSQL 9 Administration Cookbook Second Edition by Riggs Simon & Ciolli Gianni & Krosing Hannu & Bartolini Gabriele

Author:Riggs, Simon & Ciolli, Gianni & Krosing, Hannu & Bartolini, Gabriele
Language: eng
Format: epub
Publisher: Packt Publishing
Published: 2015-04-29T16:00:00+00:00

Getting ready

First, you need to consider that only simple views can be made to receive insertions, updates, and deletions easily. The SQL standard differentiates between views that are "simple updatable" and more complex views that cannot be expected to be updatable.

So, before we proceed, we need to understand what is a simply updatable view and what is not. Let's start from the cust table:

postgres=# SELECT * FROM cust; customerid | firstname | lastname | age ------------+-----------+----------+----- 1 | Philip | Marlowe | 38 2 | Richard | Hannay | 42 3 | Holly | Martins | 25 4 | Harry | Palmer | 36 4 | Mark | Hall | 47 (5 rows)

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.