Part IV. Reference

Explore the comprehensive SQL reference at Tacnode. Access detailed documentation, syntax guides, and examples to enhance your database management skills effectively.

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