Part IV. Reference
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 ProtonBase, 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
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
psql — PostgreSQL interactive terminal