Home Explore Blog CI



postgresql

3rd chunk of `doc/src/sgml/reference.sgml`
35222032bf5e00f0a6dca8220107754103b0221f1648fb6a0000000100000bf8
 &dropForeignTable;
   &dropFunction;
   &dropGroup;
   &dropIndex;
   &dropLanguage;
   &dropMaterializedView;
   &dropOperator;
   &dropOperatorClass;
   &dropOperatorFamily;
   &dropOwned;
   &dropPolicy;
   &dropProcedure;
   &dropPublication;
   &dropRole;
   &dropRoutine;
   &dropRule;
   &dropSchema;
   &dropSequence;
   &dropServer;
   &dropStatistics;
   &dropSubscription;
   &dropTable;
   &dropTableSpace;
   &dropTSConfig;
   &dropTSDictionary;
   &dropTSParser;
   &dropTSTemplate;
   &dropTransform;
   &dropTrigger;
   &dropType;
   &dropUser;
   &dropUserMapping;
   &dropView;
   &end;
   &execute;
   &explain;
   &fetch;
   &grant;
   &importForeignSchema;
   &insert;
   &listen;
   &load;
   &lock;
   &merge;
   &move;
   &notify;
   &prepare;
   &prepareTransaction;
   &reassignOwned;
   &refreshMaterializedView;
   &reindex;
   &releaseSavepoint;
   &reset;
   &revoke;
   &rollback;
   &rollbackPrepared;
   &rollbackTo;
   &savepoint;
   &securityLabel;
   &select;
   &selectInto;
   &set;
   &setConstraints;
   &setRole;
   &setSessionAuth;
   &setTransaction;
   &show;
   &startTransaction;
   &truncate;
   &unlisten;
   &update;
   &vacuum;
   &values;

 </reference>

 <reference id="reference-client">
  <title>PostgreSQL Client Applications</title>

  <partintro>
   <para>
    This part contains reference information for
    <productname>PostgreSQL</productname> client applications and
    utilities.  Not all of these commands are of general utility; some
    might require special privileges.  The common feature of these
    applications is that they can be run on any host, independent of
    where the database server resides.
   </para>

   <para>
    When specified on the command line, user and database names have
    their case preserved &mdash; the presence of spaces or special
    characters might require quoting.  Table names and other identifiers
    do not have their case preserved, except where documented, and
    might require quoting.
   </para>
  </partintro>

   &clusterdb;
   &createdb;
   &createuser;
   &dropdb;
   &dropuser;
   &ecpgRef;
   &pgamcheck;
   &pgBasebackup;
   &pgbench;
   &pgCombinebackup;
   &pgConfig;
   &pgDump;
   &pgDumpall;
   &pgIsready;
   &pgReceivewal;
   &pgRecvlogical;
   &pgRestore;
   &pgVerifyBackup;
   &psqlRef;
   &reindexdb;
   &vacuumdb;

 </reference>

 <reference id="reference-server">
  <title>PostgreSQL Server Applications</title>

  <partintro>
   <para>
    This part contains reference information for
    <productname>PostgreSQL</productname> server applications and
    support utilities.  These commands can only be run usefully on the
    host where the database server resides.  Other utility programs
    are listed in <xref linkend="reference-client"/>.
   </para>
  </partintro>

   &initdb;
   &pgarchivecleanup;
   &pgChecksums;
   &pgControldata;
   &pgCreateSubscriber;
   &pgCtl;
   &pgResetwal;
   &pgRewind;
   &pgtestfsync;
   &pgtesttiming;
   &pgupgrade;
   &pgwaldump;
   &pgwalsummary;
   &postgres;

 </reference>

</part>

Title: SQL Commands, Client and Server Applications
Summary
The text lists SQL commands (DROP, END, EXECUTE, etc.), continuing from a previous section. It then introduces PostgreSQL client applications (clusterdb, createdb, psql, etc.) that can be run on any host, followed by PostgreSQL server applications (initdb, pg_ctl, etc.) meant to be run on the database server's host. This provides a comprehensive overview of available commands and utilities within the PostgreSQL ecosystem, differentiating between those usable remotely and those requiring local server access.