What is "postgresql"

Postgresql^{(in English)} (often Postgres, never Postgre^{(in English)}), is an object-relational database management system (ORDBMS) available for multiple operating systems. It is released under the Postgresql license, which is an MIT-style license, and is therefore free and open source software. Postgresql is developed by the Postgresql Global Development Group, composed of volunteers hired and supervised by companies such as Red Hat and Enterprisedb.

Features of Postgresql

• Implements most SQL: 2008 standard
• In accordance with ACID^{(in English)}
• Utterly transactional^{(in English)} (including all DDL instructions)
• Extensible data types, operators, indexing, functions, aggregates, procedural languages
• Large number of extensions of both packaged^{(in English)} and provided by third parties^{(in English)}
• Supported operating systems^{(in English)} include: Linux, Freebsd, Solaris, Microsoft Windows, macOS
• Detailed, comprehensive and clear documentation^{(in English)}

Resources

• Advantages of Postgresql^{(in English)}
• Postgresql in Wikipedia
• Handbook^{(in English)}
• Postgresql wiki^{(in English)}
• Archives of the mailing list^{(in English)}
• Postgresql IRC channels^{(in English)}
• Chat Stack Exchange for Postgresql^{(in English)}
• Books^{(in English)}

How to ask good questions

• Show your version of Postgresql from SELECT version ().

• Include full text of relevant error messages, SQL queries, etc

• Where the proper offer of a case test with statements CREATE TABLE and INSERT with sample data and a manual table of "expected results". Sqlfiddle^{(in English)} is useful for this.

• If you previously asked something related, add a link.

• If you are repeating here a question posted on a mailing list, add a link to the page on mailing list archives^{(in English)}.

To see performance issues: Postgresql - performance^{(in English)}.

The Postgresql Reporting Guide^{(in English)} is a useful read.