Let’s start at the very beginning, what is PostgreSQL?
PostgreSQL (pronounced as /ˈpoʊstɡrɛs ˌkjuː ˈɛl/) is a multi-purpose object-relational database management system. PostgreSQL is sometimes referred to as Postgres. The PostgreSQL database first started as POSTGRES in 1986 at the University of California at Berkeley. In 1996, the project was renamed to PostgreSQL to reflect its support for SQL. PostgreSQL has a strong reputation for its proven architecture, reliability, data integrity, robust feature set, and extensibility.
PostgreSQL is an ACID compliant object-relational data which gives it some advantages over other open source SQL databases like MySQL. An object-relational database has support for user-defined objects and their related data types, functions, operators, domains and indexes. This makes PostgreSQL extremely flexible and robust. PostgreSQL is also well supported through a strong open source community and commercial support options.
Who uses PostgreSQL
Many companies, individuals, schools, and other institutions use PostgreSQL. Some of the companies using PostgreSQL include BMW, Nokia, Bloomberg, Cloudera, Reddit, and Goldman Sachs.
Next: Connecting to PostgreSQL