The entries in this Reference are meant to provide in reasonable length an authoritative, complete, and formal summary about their respective subjects. More information about the use of Tacnode, in narrative, tutorial, or example form, can be found in other parts of this book. See the cross-references listed on each reference page.

The reference entries are also available as traditional “man” pages.

Table of Contents

I. SQL Commands

 ABORT — abort the current transaction

 ALTER DATABASE — change a database

 ALTER DEFAULT PRIVILEGES — define default access privileges

 ALTER EXTENSION — change the definition of an extension

 ALTER FOREIGN DATA WRAPPER - change the definition of a foreign-data wrapper

 ALTER FOREIGN TABLE - change the definition of a foreign table

 ALTER MATERIALIZED VIEW — change the definition of a materialized view

 ALTER SCHEMA — change the definition of a schema

 ALTER SEQUENCE — change the definition of a sequence generator

 ALTER SERVER — change the definition of a foreign server

 ALTER TABLE — change the definition of a table

 ALTER USER MAPPING — change the definition of a user mapping

 ALTER VIEW — change the definition of a view

 ANALYZE — collect statistics about a database

 BEGIN — start a transaction block

 CHECKPOINT — force a write-ahead log checkpoint

 COMMENT — define or change the comment of an object

 COMMIT — commit the current transaction

 COPY — copy data between a file and a table

 CREATE DATABASE — create a new database

 CREATE EXTENSION — install an extension

 CREATE FOREIGN DATA WRAPPER — define a new foreign-data wrapper

 CREATE FOREIGN TABLE — define a new foreign table

 CREATE MATERIALIZED VIEW — define a new materialized view

 CREATE SCHEMA — define a new schema

 CREATE SEQUENCE — define a new sequence generator

 CREATE TABLE — define a new table

 CREATE SERVER — define a new foreign server

 CREATE TABLE AS — define a new table from the results of a query

 CREATE USER MAPPING — define a new mapping of a user to a foreign server

 CREATE VIEW — define a new view

 DEALLOCATE — deallocate a prepared statement

 DELETE — delete rows of a table

 DISCARD — discard session state

 DROP DATABASE — remove a database

 DROP EXTENSION — remove an extension

 DROP FOREIGN DATA WRAPPER — remove a foreign-data wrapper

 DROP FOREIGN TABLE — remove a foreign table

 DROP MATERIALIZED VIEW — remove a materialized view

 DROP SCHEMA — remove a schema

 DROP SEQUENCE — remove a sequence

 DROP SERVER — remove a foreign server descriptor

 DROP TABLE — remove a table

 DROP USER MAPPING — remove a user mapping for a foreign server

 DROP VIEW — remove a view

 END — commit the current transaction

 EXECUTE — execute a prepared statement

 EXPLAIN — show the execution plan of a statement

 GRANT — define access privileges

 IMPORT FOREIGN SCHEMA - import table definitions from a foreign server

 INSERT — create new rows in a table

 PREPARE — prepare a statement for execution

 REASSIGN OWNED — change the ownership of database objects owned by a database role

 REFRESH MATERIALIZED VIEW — replace the contents of a materialized view

 REINDEX — rebuild indexes

 RELEASE SAVEPOINT — destroy a previously defined savepoint

 RESET — restore the value of a run-time parameter to the default value

 REVOKE — remove access privileges

 ROLLBACK — abort the current transaction

 ROLLBACK TO SAVEPOINT — roll back to a savepoint

 SAVEPOINT — define a new savepoint within the current transaction

 SELECT — retrieve rows from a table or view

 SELECT INTO — define a new table from the results of a query

 SET — change a run-time parameter

 SET ROLE — set the current user identifier of the current session

 SET TRANSACTION — set the characteristics of the current transaction

 SHOW — show the value of a run-time parameter

 START TRANSACTION — start a transaction block

 TRUNCATE — empty a table or set of tables

 UPDATE — update rows of a table

 VALUES — compute a set of rows

II. PostgreSQL Client Applications

 psql — PostgreSQL interactive terminal