begriffs open source - ai-pg/blob - full-docs/src/sgml/html/intro-whatis.html

   1 <?xml version="1.0" encoding="UTF-8" standalone="no"?>
   2 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>1.  What Is PostgreSQL?</title><link rel="stylesheet" type="text/css" href="stylesheet.css" /><link rev="made" href="pgsql-docs@lists.postgresql.org" /><meta name="generator" content="DocBook XSL Stylesheets Vsnapshot" /><link rel="prev" href="preface.html" title="Preface" /><link rel="next" href="history.html" title="2. A Brief History of PostgreSQL" /></head><body id="docContent" class="container-fluid col-10"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="5" align="center">1.  What Is <span class="productname">PostgreSQL</span>?</th></tr><tr><td width="10%" align="left"><a accesskey="p" href="preface.html" title="Preface">Prev</a> </td><td width="10%" align="left"><a accesskey="u" href="preface.html" title="Preface">Up</a></td><th width="60%" align="center">Preface</th><td width="10%" align="right"><a accesskey="h" href="index.html" title="PostgreSQL 18.0 Documentation">Home</a></td><td width="10%" align="right"> <a accesskey="n" href="history.html" title="2. A Brief History of PostgreSQL">Next</a></td></tr></table><hr /></div><div class="sect1" id="INTRO-WHATIS"><div class="titlepage"><div><div><h2 class="title" style="clear: both">1.  What Is <span class="productname">PostgreSQL</span>? <a href="#INTRO-WHATIS" class="id_link">#</a></h2></div></div></div><p>
   3    <span class="productname">PostgreSQL</span> is an object-relational
   4    database management system (<acronym class="acronym">ORDBMS</acronym>) based on
   5    <a class="ulink" href="https://dsf.berkeley.edu/postgres.html" target="_top">
   6    <span class="productname">POSTGRES, Version 4.2</span></a>,
   7    developed at the University of California at Berkeley Computer Science
   8    Department.  POSTGRES pioneered many concepts that only became
   9    available in some commercial database systems much later.
  10   </p><p>
  11    <span class="productname">PostgreSQL</span> is an open-source descendant
  12    of this original Berkeley code.  It supports a large part of the SQL
  13    standard and offers many modern features:
  14
  15    </p><div class="itemizedlist"><ul class="itemizedlist compact" style="list-style-type: disc; "><li class="listitem"><a class="link" href="sql.html" title="Part II. The SQL Language">complex queries</a></li><li class="listitem"><a class="link" href="ddl-constraints.html#DDL-CONSTRAINTS-FK" title="5.5.5. Foreign Keys">foreign keys</a></li><li class="listitem"><a class="link" href="triggers.html" title="Chapter 37. Triggers">triggers</a></li><li class="listitem"><a class="link" href="sql-createview.html#SQL-CREATEVIEW-UPDATABLE-VIEWS" title="Updatable Views">updatable views</a></li><li class="listitem"><a class="link" href="transaction-iso.html" title="13.2. Transaction Isolation">transactional integrity</a></li><li class="listitem"><a class="link" href="mvcc.html" title="Chapter 13. Concurrency Control">multiversion concurrency control</a></li></ul></div><p>
  16
  17    Also, <span class="productname">PostgreSQL</span> can be extended by the
  18    user in many ways, for example by adding new
  19
  20    </p><div class="itemizedlist"><ul class="itemizedlist compact" style="list-style-type: disc; "><li class="listitem"><a class="link" href="datatype.html" title="Chapter 8. Data Types">data types</a></li><li class="listitem"><a class="link" href="functions.html" title="Chapter 9. Functions and Operators">functions</a></li><li class="listitem"><a class="link" href="functions.html" title="Chapter 9. Functions and Operators">operators</a></li><li class="listitem"><a class="link" href="functions-aggregate.html" title="9.21. Aggregate Functions">aggregate functions</a></li><li class="listitem"><a class="link" href="indexes.html" title="Chapter 11. Indexes">index methods</a></li><li class="listitem"><a class="link" href="server-programming.html" title="Part V. Server Programming">procedural languages</a></li></ul></div><p>
  21   </p><p>
  22    And because of the liberal license,
  23    <span class="productname">PostgreSQL</span> can be used, modified, and
  24    distributed by anyone free of charge for any purpose, be it
  25    private, commercial, or academic.
  26   </p></div><div class="navfooter"><hr /><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="preface.html" title="Preface">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="preface.html" title="Preface">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="history.html" title="2. A Brief History of PostgreSQL">Next</a></td></tr><tr><td width="40%" align="left" valign="top">Preface </td><td width="20%" align="center"><a accesskey="h" href="index.html" title="PostgreSQL 18.0 Documentation">Home</a></td><td width="40%" align="right" valign="top"> 2. A Brief History of <span class="productname">PostgreSQL</span></td></tr></table></div></body></html>