Appendix D. PostgreSQL features
In this appendix, we’ll give you a taste of the uniqueness and versatility of PostgreSQL that makes it stand apart from the other databases you may be familiar with. This is by no means the extent of what is offered by PostgreSQL, and we encourage you to reference its very detailed and extensive manuals when you need to learn more about a specific feature.
PostgreSQL has many features that are rarely found in other databases, and some of its features don’t exist in any other databases. It also has perhaps the most extensible type and index architecture of any relational database. This extensible architecture is the main reason it was chosen as a vehicle to house PostGIS functionality.
PostgreSQL has features you’ll rarely find in other databases. Here are the key ones that set it apart it from most other databases you may have worked with: