Bruce Momjian, PostgreSQL Project
Date: Monday, July 07
Time: 8:45am - 12:15pm
Location: Salon H
As an object-relational database, PostgreSQL has powerful capabilities to push common processing tasks into the database server. This eases programming and administration, and makes code cleaner and easier to manage.
Momjian's tutorial explores these capabilities. They include constraints, server-side functions, triggers, rules, views, server-side languages, user-defined types, domains, casts, sequences, and user-defined operators. Some of these are standard SQL, while others are unique to PostgreSQL.
In summary, these enable you to put "smarts" into your database, allowing for more efficient design and management.