Home Explore Blog CI



postgresql

3rd chunk of `doc/src/sgml/postgres.sgml`
f584af9f86820dd14d15eb0a4f18006ac9e59ab47f3329ed0000000100000de8
 for a complete
    description of a command are encouraged to review the
    <xref linkend="reference"/>.
   </para>

   <para>
    The first few chapters are written so they can be understood
    without prerequisite knowledge, so new users who need to set
    up their own server can begin their exploration. The rest of this
    part is about tuning and management; that material
    assumes that the reader is familiar with the general use of
    the <productname>PostgreSQL</productname> database system.  Readers are
    encouraged review the <xref linkend="tutorial"/> and <xref
    linkend="sql"/> parts for additional information.
   </para>
  </partintro>

  &installbin;
  &installation;
  &runtime;
  &config;
  &client-auth;
  &user-manag;
  &manage-ag;
  &charset;
  &maintenance;
  &backup;
  &high-availability;
  &monitoring;
  &wal;
  &logical-replication;
  &jit;
  &regress;

 </part>

 <part id="client-interfaces">
  <title>Client Interfaces</title>

  <partintro>
   <para>
    This part describes the client programming interfaces distributed
    with <productname>PostgreSQL</productname>.  Each of these chapters can be
    read independently.  There are many external programming
    interfaces for client programs that are distributed separately. They
    contain their own documentation (<xref linkend="external-projects"/>
    lists some of the more popular ones).  Readers of this part should be
    familiar with using <acronym>SQL</acronym> to manipulate
    and query the database (see <xref linkend="sql"/>) and of course
    with the programming language of their choice.
   </para>
  </partintro>

  &libpq;
  &lobj;
  &ecpg;
  &infoschema;

 </part>

 <part id="server-programming">
  <title>Server Programming</title>

  <partintro>
   <para>
    This part is about extending the server functionality with
    user-defined functions, data types, triggers, etc.  These are
    advanced topics which should be approached only after all
    the other user documentation about <productname>PostgreSQL</productname> has
    been understood.  Later chapters in this part describe the server-side
    programming languages available in the
    <productname>PostgreSQL</productname> distribution as well as
    general issues concerning server-side programming.  It
    is essential to read at least the earlier sections of <xref
    linkend="extend"/> (covering functions) before diving into the
    material about server-side programming.
   </para>
  </partintro>

  &extend;
  &trigger;
  &event-trigger;
  &rules;

  &xplang;
  &plsql;
  &pltcl;
  &plperl;
  &plpython;

  &spi;
  &bgworker;
  &logicaldecoding;
  &replication-origins;
  &archive-modules;
  &oauth-validators;

 </part>

 &reference;

 <part id="internals">
  <title>Internals</title>

  <partintro>
   <para>
    This part contains assorted information that might be of use to
    <productname>PostgreSQL</productname> developers.
   </para>
  </partintro>

  &arch-dev;
  &catalogs;
  &system-views;
  &protocol;
  &sources;
  &nls;
  &plhandler;
  &fdwhandler;
  &tablesample-method;
  &custom-scan;
  &geqo;
  &tableam;
  &indexam;
  &wal-for-extensions;
  &indextypes;
  &storage;
  &transaction;
  &bki;
  &planstats;
  &backup-manifest;

 </part>

 <part id="appendixes">
  <title>Appendixes</title>

  &errcodes;
  &datetime;
  &keywords;
  &features;
  &release;
  &contrib;
  &external-projects;
  &sourcerepo;
  &docguide;
  &limits;
  &acronyms;
  &glossary;
  &color;
  &obsolete;

 </part>

 &biblio;
 <index id="bookindex"></index>

</book>

Title: PostgreSQL Client Interfaces, Server Programming, Internals, and Appendixes
Summary
This section outlines the client programming interfaces for PostgreSQL, including libpq, lobj, ecpg, and infoschema. It then dives into server programming topics such as extending server functionality with user-defined functions, data types, and triggers, emphasizing the need for a strong understanding of PostgreSQL fundamentals before delving into these advanced areas. It covers server-side programming languages like PL/pgSQL, PL/Tcl, PL/Perl, and PL/Python. Additionally, it provides internal information useful for PostgreSQL developers, and various appendixes, covering error codes, datetime formats, keywords, features, release notes, contributed modules, external projects, source repository information, documentation guide, limits, acronyms, a glossary, color usage, and obsolete features.