Characteristics
For this reason, we are going to list the most important features of PostgreSQL for you:
- The SQL language it uses is very close to the ISO/IEC standard, making it relatively easy to port queries and scripts from other database systems, and thus easily learn the variants of this language.
- It complies with ACID, that is, it provides atomicity, consistency, isolation and durability for its operations.
- It allows you to create schemas, inherited tables and event-oriented triggers that other engines do not have.
- It allows you to define procedures, not only in PostgreSQL, but also in many other languages such as Pearl, TCL or Python. Even if the language we want to use is not supported, we can define it with new extensions.
- If we need some type of data that is not supported as standard, we can also define them.
- We can extend the functionality with extensions, provided by PostgreSQL itself, by third parties or even programming on our own.
- It has native master-slave replication support, but it is also possible to add other types through free or paid third-party products.
- It also provides excellent vertical scalability.