Open source object-relational database with SQL, transactions, triggers, and user-defined types
Other
- C
- PLpgSQL
- Perl

About PostgreSQL
PostgreSQL is an advanced object-relational database management system. It stores and queries structured data using an extended subset of the SQL standard, with transactions, foreign keys, subqueries, triggers, user-defined types, and user-defined functions.
Because types and functions are user-extensible, you can model domain-specific data inside the database rather than working around a fixed schema. C language bindings let applications talk to the server directly, and the system runs as a self-hosted server on a wide range of operating systems.
PostgreSQL is released under its own permissive license and developed by the PostgreSQL Global Development Group. It is widely used as a general-purpose relational backend for everything from small applications to large production systems.
Key features
- Extended SQL with transactions and foreign keys
- Subqueries, triggers, and user-defined types
- User-defined functions
- C language bindings for client applications
Details
- Type
- Object-relational database
- Query language
- SQL
- Language
- C
- Maintainer
- PostgreSQL Global Development Group
- Deployment
- Self-hostable
- License
- PostgreSQL License
