- Table of Contents
- ABORT — Rolls back changes made during a transaction block.
- ALTER GROUP — Modifies the structure of a user group.
- ALTER TABLE — Modifies table, row, and column attributes.
- ALTER USER — Modifies user account properties and permissions.
- BEGIN — Starts a chained-mode transaction block.
- CLOSE — Closes a previously defined cursor object.
- CLUSTER — Provides the backend server with clustering information about a table.
- COMMENT — Adds a comment to an object within the database.
- COMMIT — Ends the current transaction block and finalizes changes made within it.
- COPY — Copeis filesystem data and row data between files andt tables.
Copies data between files and tables
- CREATE AGGREGATE — Defines a new aggregate function within the database.
- CREATE CONSTRAINT TRIGGER — Creates a trigger for use with a constraint.
- CREATE DATABASE — Creates a new database on the system.
- CREATE FUNCTION — Defines a new function within the database.
- CREATE GROUP — Creates a new user group within the database.
- CREATE INDEX — Constructs an index on a table.
- CREATE LANGUAGE — Defines a new language to be used by functions.
- CREATE OPERATOR — Defines a new operator within the database.
- CREATE RULE — Defines a new rule on a table.
- CREATE SEQUENCE — Creates a new sequence number generator.
- CREATE TABLE — Creates a new table.
- CREATE TABLE AS — Creates a new table built from data retrieved by a SELECT.
- CREATE TRIGGER — Creates a new trigger.
- CREATE TYPE — Defines a new data type for use in the database.
- CREATE USER — Creates a new user account.
- CREATE VIEW — Creates a new view on a table.
- createdb — Creates a new database from the command line.
- createlang — Defines a new programming language for use by functions within a database.
- createuser — Adds a new user account to a database.
- SQL_CURRENT_DATE — Returns the current date.
- SQL_CURRENT_TIME — Returns the current time.
- SQL_CURRENT_TIMESTAMP — Returns the current date and time.
- SQL_CURRENT_USER — Returns the current database username.
- DECLARE — Defines a new cursor.
- DELETE — Removes rows from a table.
- DROP AGGREGATE — Removes the definition of an aggregate function from the database.
- DROP DATABASE — Removes a database from the system.
- DROP FUNCTION — Removes a user-defined C function.
- DROP GROUP — Removes a user group from the database.
- DROP INDEX — Removes an index from a database.
- DROP LANGUAGE — Removes the definition of a procedural language.
- DROP OPERATOR — Removes an operator from the database.
- DROP RULE — Removes a rule from a database.
- DROP SEQUENCE — Removes an existing sequence from a database.
- DROP TABLE — Removes a table from a database
- DROP TRIGGER — Removes the definition of a trigger from a database.
- DROP TYPE — Removes a type from the system catalogs.
- DROP USER — Removes a user account from a database.
- DROP VIEW — Removes an existing view from a database.
- dropdb — Removes a database from the system.
- droplang — Removes the definition of a procedural language from a database.
- dropuser — Removes a user account from a database.
- ecpg — The embedded SQL C preprocessor.
- END — Ends the current transaction block and finalizes its modifications.
- EXPLAIN — Shows the statement execution plan for a supplied query.
- FETCH — Retrieves rows from a cursor.
- GRANT — Grants access privileges to a user, group, or all of the users in the database.
- initdb — Creates a new database cluster.
- initlocation — Create a secondary PostgreSQL database storage area
- INSERT — Inserts new rows into a table.
- ipcclean — Cleans shared memory resources left behind by aborted backend processes.
- LISTEN — Listen for a notification event.
- LOAD — Dynamically loads object files into a database.
- LOCK — Explicitly locks a specified table within the current transaction.
- MOVE — Repositions the cursor to another row.
- NOTIFY — Signals all backends that are listening for the specified notify event.
- pg_dump — Exports a database to a script file.
- pg_dumpall — Exports all databases on the system to a script file.
- pg_ctl — Starts, stops, and restarts postmaster.
- pgtclsh — The TCL database client.
- pgtksh — A graphical TCL/TK database client.
- postgres — Runs a single-user backend process.
- postmaster — Executes the PostgreSQL multi-user backend process.
- psql — The PostgreSQL interactive terminal.
- REINDEX — Rebuilds indexes on tables.
- RESET — Restores run-time variables to their default settings.
- REVOKE — Revokes access privileges from a user, a group, or all users.
- ROLLBACK — Aborts the current transaction black and abandons any modifications it would have made.
- SELECT — Retrieves rows from a table or view.
- SELECT INTO — Construct a new table from the results of a SELECT.
- SET — Set run-time variables.
- SET CONSTRAINTS — Sets the constraint mode for the current transaction block.
- SET TRANSACTION — Sets the transaction isolation mode for the current transaction block.
- SHOW — Displays the values of run-time variables.
- TRUNCATE — Empties the contents of a table.
- UNLISTEN — Stops the backend process from listening for a notification event.
- UPDATE — Modifies the values of column data within a table.
- VACUUM — Cleans and analyzes a database.
- vacuumdb — Cleans and analyzes a database.