1. What isPostgres Pro Standard?
Postgres Pro Standard is an object-relational database management system (ORDBMS), developed by Postgres Professional in thePostgres Pro fork ofPostgreSQL, which is in turn based onPOSTGRES, Version 4.2, developed at the University of California at Berkeley Computer Science Department. POSTGRES pioneered many concepts that only became available in some commercial database systems much later.
BothPostgreSQL andPostgres Pro Standard support a large part of the SQL standard and offer many modern features:
- complex queries
- foreign keys
- triggers
- updatable views
- transactional integrity
- multiversion concurrency control
Besides,PostgreSQL andPostgres Pro can be extended by the user in many ways, for example by adding new
- data types
- functions
- operators
- aggregate functions
- index methods
- procedural languages