PostgreSQL Advanced Building Blocks

In this chapter, the rest of the PostgreSQL building blocks, including views, indexes, functions, triggers, and rules will be introduced. In addition to that, the web car portal schema will be revised. Several DDL commands, such as CREATE and ALTER, will also be introduced. Since the lexical structure and several DML commands have not been introduced as yet, we will try to use simple DML commands. In this chapter the topics we will be covering include:

• Views: views is an important part of database modelling because the act as an interface or as an abstraction layer. The view section will discuses view synopsis, usages, and an updatable view example will be demonstrated. 
• Indexes: indexes is the secret sauce to insure consistency and performance. Indexes types will be discussed.
• Functions: Functions can be used to perform very complex...