PostgreSQL
Open-source relational database management system
PostgreSQL (often referred to as Postgres) is an open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. It was originally named POSTGRES, referring to its origins as a successor to the Ingres database developed at the University of California, Berkeley.
History[edit | edit source]
PostgreSQL's development began in 1986 under the direction of Professor Michael Stonebraker as part of the POSTGRES project at Berkeley. The project aimed to add the fewest features needed to support complex data types for new applications. In 1996, the project was renamed to PostgreSQL to reflect its support for SQL.
Features[edit | edit source]
PostgreSQL offers a wide range of features that comply with the SQL:2011 standard, including:
- ACID compliance
- Foreign keys
- Triggers
- Views
- Transactional integrity
- Multi-Version Concurrency Control (MVCC)
Additionally, PostgreSQL supports:
- Stored procedures and functions
- Custom data types
- Indexing techniques such as B-tree, hash, GiST, GIN, and SP-GiST
- Full-text search
- JSON and XML data types
- Replication (both synchronous and asynchronous)
Extensibility[edit | edit source]
One of PostgreSQL's most notable features is its extensibility. Users can define their own:
Procedural Languages[edit | edit source]
PostgreSQL supports several procedural languages, including:
Community and Development[edit | edit source]
PostgreSQL is developed by a global community of developers and companies. The PostgreSQL Global Development Group (PGDG) oversees the development and release process. The community provides extensive documentation, mailing lists, and support forums.
Use Cases[edit | edit source]
PostgreSQL is used in various applications, from web and mobile applications to data warehousing and analytics. Its robustness and feature set make it suitable for both small and large-scale applications.
Related Pages[edit | edit source]
- Relational database management system
- SQL
- Ingres (database)
- Michael Stonebraker
- ACID
- Multi-Version Concurrency Control
- Replication (computing)
See Also[edit | edit source]
- List of relational database management systems
- Comparison of relational database management systems
- Database management system
Categories[edit | edit source]
| Types | |
|---|---|
| Concepts | |
| Objects | |
| Components | |
| Functions | |
| Related topics | |
 | This medical article is a stub. You can help WikiMD by expanding it. |
Search WikiMD
Ad.Tired of being Overweight? Try W8MD's physician weight loss program.
Semaglutide (Ozempic / Wegovy and Tirzepatide (Mounjaro / Zepbound) available.
Advertise on WikiMD
|
WikiMD's Wellness Encyclopedia |
| Let Food Be Thy Medicine Medicine Thy Food - Hippocrates |
Translate this page: - East Asian
中文,
日本,
한국어,
South Asian
हिन्दी,
தமிழ்,
తెలుగు,
Urdu,
ಕನ್ನಡ,
Southeast Asian
Indonesian,
Vietnamese,
Thai,
မြန်မာဘာသာ,
বাংলা
European
español,
Deutsch,
français,
Greek,
português do Brasil,
polski,
română,
русский,
Nederlands,
norsk,
svenska,
suomi,
Italian
Middle Eastern & African
عربى,
Turkish,
Persian,
Hebrew,
Afrikaans,
isiZulu,
Kiswahili,
Other
Bulgarian,
Hungarian,
Czech,
Swedish,
മലയാളം,
मराठी,
ਪੰਜਾਬੀ,
ગુજરાતી,
Portuguese,
Ukrainian
Medical Disclaimer: WikiMD is not a substitute for professional medical advice. The information on WikiMD is provided as an information resource only, may be incorrect, outdated or misleading, and is not to be used or relied on for any diagnostic or treatment purposes. Please consult your health care provider before making any healthcare decisions or for guidance about a specific medical condition. WikiMD expressly disclaims responsibility, and shall have no liability, for any damages, loss, injury, or liability whatsoever suffered as a result of your reliance on the information contained in this site. By visiting this site you agree to the foregoing terms and conditions, which may from time to time be changed or supplemented by WikiMD. If you do not agree to the foregoing terms and conditions, you should not enter or use this site. See full disclaimer.
Credits:Most images are courtesy of Wikimedia commons, and templates Wikipedia, licensed under CC BY SA or similar.
Contributors: Prab R. Tumpati, MD
