Understand PostgreSQL extensions Beyond standard SQL, PostgreSQL supports several advanced features: views, foreign keys, transactions, window functions, and schema inheritance.

The advanced data types introduced in this section give a relational database more flexibility in what can be used as a value for a table column. For example, a column can be used to store BLOB ...