PostgreSQL: Documentation

<!doctype html> <html lang="en"> <head> <title>PostgreSQL: Documentation</title> <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"> <meta http-equiv="Content-Type" content="text/xhtml; charset=utf-8" /> <meta name="theme-color" content="#336791"/> <meta name="copyright" content="The PostgreSQL Global Development Group" /> <link href="/media/css/fontawesome.css?18db9df6" rel="stylesheet"> <link rel="stylesheet" href="/media/css/bootstrap-4.4.1.min.css"> <link rel="shortcut icon" href="/favicon.ico" /> <link rel="stylesheet" type="text/css" href="/dyncss/base.css?18db9df6"> <script src="/media/js/theme.js?18db9df6"></script> </head> <body> <div class="container-fluid"> <div class="row justify-content-md-center"> <div class="col">  <nav class="navbar navbar-expand-lg navbar-light bg-light"> <a class="navbar-brand p-0" href="/"> <img class="logo" src="/media/img/about/press/elephant.png" alt="PostgreSQL Elephant Logo"> </a> <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#pgNavbar" aria-controls="pgNavbar" aria-expanded="false" aria-label="Toggle navigation"> <span class="navbar-toggler-icon"></span> </button> <div class="collapse navbar-collapse" id="pgNavbar"> <ul class="navbar-nav mr-auto"> <li class="nav-item p-2"><a href="/" title="Home">Home</a></li> <li class="nav-item p-2"><a href="/about/" title="About">About</a></li> <li class="nav-item p-2"><a href="/download/" title="Download">Download</a></li> <li class="nav-item p-2"><a href="/docs/" title="Documentation">Documentation</a></li> <li class="nav-item p-2"><a href="/community/" title="Community">Community</a></li> <li class="nav-item p-2"><a href="/developer/" title="Developers">Developers</a></li> <li class="nav-item p-2"><a href="/support/" title="Support">Support</a></li> <li class="nav-item p-2"><a href="/about/donate/" title="Donate">Donate</a></li> <li class="nav-item p-2"><a href="/account/" title="Your account">Your account</a></li> </ul> <form role="search" method="get" action="/search/"> <div class="input-group"> <input id="q" name="q" type="text" size="20" maxlength="255" accesskey="s" class="form-control" placeholder="Search for..."> <span class="input-group-btn"> <button class="btn btn-default" type="submit"><i class="fas fa-search"></i></button> </span> </div> </form> <form id="form-theme" class="form-inline d-none"> <button id="btn-theme" class="btn btn-default ml-1" type="button"></button> </form> </div> </nav> </div> </div> <div class="row justify-content-center pg-shout-box"> <div class="col text-white text-center">November 21, 2024: <a href="/about/news/postgresql-172-166-1510-1415-1318-and-1222-released-2965/"> PostgreSQL 17.2, 16.6, 15.10, 14.15, 13.18, and 12.22 Released! </a> </div> </div> </div> <div class="container-fluid margin"> <div class="row"> <div class="col-lg-2"> <div id="pgSideWrap"> <div id="pgSideNav"> <h2>Quick Links</h2> <ul> <li><a href="/docs/">Documentation</a> </li> <li><a href="/docs/">Manuals</a> <ul> <li class="last-child"><a href="/docs/manuals/archive/">Archive</a></li> </ul> </li> <li><a href="/docs/release/">Release Notes</a> </li> <li><a href="/docs/books/">Books</a> </li> <li><a href="/docs/online-resources/">Tutorials & Other Resources</a> </li> <li><a href="/docs/faq/">FAQ</a> </li> <li class="last-child"><a href="https://wiki.postgresql.org">Wiki</a> </li> </ul> </div> </div>  </div> <div class="col-lg-10"> <div id="pgContentWrap"> <div class="row"> <div class="col-md-9"> <section> <h1>Documentation <i class="far fa-file-alt"></i></h1> </section> <p> <a class="btn btn-primary btn-double-width" href="/docs/current/">View the manual</a> </p> <h2>Manuals <i class="fas fa-book"></i></h2> <p> You can view the manual for an older version or download a PDF of a manual from the below table. </p> <table class="table table-striped"> <thead> <tr> <th class="w-25">Online Version</th> <th>PDF Version</th> </tr> </thead> <tbody> <tr> <td> <a href="/docs/17/index.html">17</a> / <a href="/docs/current/index.html">Current</a> </td> <td> <a href="/files/documentation/pdf/17/postgresql-17-A4.pdf">A4 PDF</a> <span class="txtMediumGrey">(14.5聽MB)</span> • <a href="/files/documentation/pdf/17/postgresql-17-US.pdf">US PDF</a> <span class="txtMediumGrey">(14.4聽MB)</span> </tr> <tr> <td> <a href="/docs/16/index.html">16</a> </td> <td> <a href="/files/documentation/pdf/16/postgresql-16-A4.pdf">A4 PDF</a> <span class="txtMediumGrey">(14.3聽MB)</span> • <a href="/files/documentation/pdf/16/postgresql-16-US.pdf">US PDF</a> <span class="txtMediumGrey">(14.2聽MB)</span> </tr> <tr> <td> <a href="/docs/15/index.html">15</a> </td> <td> <a href="/files/documentation/pdf/15/postgresql-15-A4.pdf">A4 PDF</a> <span class="txtMediumGrey">(13.7聽MB)</span> • <a href="/files/documentation/pdf/15/postgresql-15-US.pdf">US PDF</a> <span class="txtMediumGrey">(13.6聽MB)</span> </tr> <tr> <td> <a href="/docs/14/index.html">14</a> </td> <td> <a href="/files/documentation/pdf/14/postgresql-14-A4.pdf">A4 PDF</a> <span class="txtMediumGrey">(13.5聽MB)</span> • <a href="/files/documentation/pdf/14/postgresql-14-US.pdf">US PDF</a> <span class="txtMediumGrey">(13.4聽MB)</span> </tr> <tr> <td> <a href="/docs/13/index.html">13</a> </td> <td> <a href="/files/documentation/pdf/13/postgresql-13-A4.pdf">A4 PDF</a> <span class="txtMediumGrey">(13.1聽MB)</span> • <a href="/files/documentation/pdf/13/postgresql-13-US.pdf">US PDF</a> <span class="txtMediumGrey">(13.0聽MB)</span> </tr> <tr> <td><a href="/docs/devel/index.html">Development snapshot</a></td> <td>PDF version not available</td> </tr> </tbody> </table> <p> Looking for documentation for an older, unsupported, version? Check the <a href="/docs/manuals/archive/">archive</a> of older manuals. </p> </div> <div class="col-md-3"> <section> <h2>Translated Manuals</h2> </section> <ul> <li><a href="http://www.postgres.cn/docs" target="_blank" rel="noopener">Chinese</a></li> <li><a href="https://docs.postgresql.fr" target="_blank" rel="noopener">French</a></li> <li><a href="https://www.postgresql.jp/document/" target="_blank" rel="noopener">Japanese</a></li> <li><a href="https://postgrespro.ru/docs/postgresql" target="_blank" rel="noopener">Russian</a></li> </ul> </div> </div> </div>  </div> </div> </div>  <footer id="footer"> <div class="container"> <div class="row"> <div class="col-md-12"> <ul> <li><a href="https://twitter.com/postgresql"><img src="/media/img/atpostgresql.png" alt="@postgresql"></a></li> <li><a href="https://git.postgresql.org/gitweb/?p=postgresql.git"><img src="/media/img/git.png" alt="Git"></a></li> </ul> </div> </div> </div>  <div class="container"> <a href="/about/policies/">Policies</a> | <a href="/about/policies/coc/">Code of Conduct</a> | <a href="/about/">About PostgreSQL</a> | <a href="/about/contact/">Contact</a><br/> <p>Copyright © 1996-2024 The PostgreSQL Global Development Group</p> </div> </footer> <script src="/media/js/jquery-3.4.1.slim.min.js"></script> <script src="/media/js/popper-1.16.0.min.js"></script> <script src="/media/js/bootstrap-4.4.1.min.js"></script> <script src="/media/js/main.js?18db9df6"></script> </body> </html>

CINXE.COM

PostgreSQL: Documentation