Home Explore Blog CI



postgresql

2nd chunk of `doc/src/sgml/reference.sgml`
ea49a453ca415fba91e5afaf93351d0e83500dc20f8395c0000000010000081b
 &createCollation;
   &createConversion;
   &createDatabase;
   &createDomain;
   &createEventTrigger;
   &createExtension;
   &createForeignDataWrapper;
   &createForeignTable;
   &createFunction;
   &createGroup;
   &createIndex;
   &createLanguage;
   &createMaterializedView;
   &createOperator;
   &createOperatorClass;
   &createOperatorFamily;
   &createPolicy;
   &createProcedure;
   &createPublication;
   &createRole;
   &createRule;
   &createSchema;
   &createSequence;
   &createServer;
   &createStatistics;
   &createSubscription;
   &createTable;
   &createTableAs;
   &createTableSpace;
   &createTSConfig;
   &createTSDictionary;
   &createTSParser;
   &createTSTemplate;
   &createTransform;
   &createTrigger;
   &createType;
   &createUser;
   &createUserMapping;
   &createView;
   &deallocate;
   &declare;
   &delete;
   &discard;
   &do;
   &dropAccessMethod;
   &dropAggregate;
   &dropCast;
   &dropCollation;
   &dropConversion;
   &dropDatabase;
   &dropDomain;
   &dropEventTrigger;
   &dropExtension;
   &dropForeignDataWrapper;
   &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;

Title: SQL Commands (Continued)
Summary
Continuation of the list of SQL commands, encompassing a wide range of operations within the PostgreSQL database system. The commands listed include those for creating various database objects such as collations, conversions, databases, domains, event triggers, extensions, foreign data wrappers, foreign tables, functions, groups, indexes, languages, materialized views, operators, operator classes, operator families, policies, procedures, publications, roles, rules, schemas, sequences, servers, statistics, subscriptions, tables, and types. Additionally, the list covers commands for deallocating, declaring, deleting, discarding, and executing operations, as well as commands for dropping database objects, managing transactions (commit, rollback), and controlling access privileges (grant, revoke). This comprehensive selection provides a foundational overview of the SQL commands available for managing and interacting with a PostgreSQL database.