PostgreSQL Syntax

We can see the syntax of all postgreSQL commands by using help command. Follow the following steps to see the syntax of all commands in postgreSQL.

  • After installing postgreSQL, open the psql as:
    Program Files > PostgreSQL 9.2 > SQL Shell(psql)
  • Use the following command to see the syntax of a specific command.
    postgres-# \help &<command_name>

All PostgreSQL commands

Here, we are providing a list of all postgreSQL commands and their syntax:

ABORT command:

Syntax:

ALTER AGGREGATE command:

Syntax:

ALTER CONVERSION command:

Syntax:

ALTER DATABASE command:

Syntax:

ALTER DOMAIN command:

Syntax:

ALTER FUNCTION command:

Syntax:

ALTER GROUP command:

Syntax:

ALTER INDEX command:

Syntax:

ALTER LANGUAGE command:

Syntax:

ALTER OPERATOR command:

Syntax:

ALTER OPERATOR CLASS command:

Syntax:

ALTER SCHEMA command:

Syntax:

ALTER SEQUENCE command:

Syntax:

ALTER TABLE command:

Syntax:

ALTER TABLESPACE command:

Syntax:

ALTER TRIGGER command:

Syntax:

ALTER TYPE command:

Syntax:

ALTER USER command:

Syntax:

ANALYSE command:

Syntax:

BEGIN command:

Syntax:

CHECKPOINT command:

Syntax:

CLOSE command:

Syntax:

CLUSTER command:

Syntax:

COMMIT command:

Syntax:

COPY command:

Syntax:

CREATE AGGREGATE command:

Syntax:

CREATE CAST command:

Syntax:

CREATE CONSTRAINT TRIGGER command:

Syntax:

CREATE CONVERSION command:

Syntax:

CREATE DATABASE command:

Syntax:

CREATE DOMAIN command:

Syntax:

CREATE FUNCTION command:

Syntax:

CREATE GROUP command:

Syntax:

CREATE INDEX command:

Syntax:

CREATE LANGUAGE command:

Syntax:

CREATE OPERATOR command:

Syntax:

CREATE OPERATOR CLASS command:

Syntax:

CREATE RULE command:

Syntax:

CREATE SCHEMA command:

Syntax:

CREATE SEQUENCE command:

Syntax:

CREATE TABLE:

Syntax:

CREATE TABLE AS command:

Syntax:

CREATE TABLESPACE command:

Syntax:

CRFEATE TRIGGER command:

Syntax:

CREATE TYPE command:

Syntax:

CREATE USER command:

Syntax:

CREATE VIEW command:

Syntax:

DEALLOCATE command:

Syntax:

DECLARE command:

Syntax:

DELETE command:

Syntax:

DROP AGGREGATE command:

Syntax:

DROP CAST command:

Syntax:

DROP CONVERSION command:

Syntax:

DROP DATABASE command:

Syntax:

DROP DOMAIN command:

Syntax:

DROP FUNCTION command:

Syntax:

DROP GROUP command:

Syntax:

DROP INDEX command:

Syntax:

DROP LANGUAGE command:

Syntax:

DROP OPERATOR command:

Syntax:

DROP OPERATOR CLASS command:

Syntax:

DROP RULE command:

Syntax:

DROP SCHEMA command:

Syntax:

DROP SEQUENCE command:

Syntax:

DROP TABLE command:

Syntax:

DROP TABLESPACE command:

Syntax:

DROP TRIGGER command:

Syntax:

DROP TYPE command:

Syntax:

DROP USER command:

Syntax:

DROP VIEW command:

Syntax:

END command:

Syntax:

EXECUTE command:

Syntax:

EXPLAIN command:

Syntax:

FETCH command:

Syntax:

INSERT command:

Syntax:

LISTEN command:

Syntax:

LOAD command:

Syntax:

LOCK command

Syntax:

MOVE command:

Syntax:

NOTIFY command:

Syntax:

PREPARE command:

Syntax:

REINDEX command:

Syntax:

RESET command:

Syntax:

ROLLBACK command:

Syntax:

ROLLBACK TO SAVEPOINT command:

Syntax:

SAVEPOINT command:

Syntax:

SELECT command:

Syntax:

SELECT INTO command:

Syntax:

SET command:

Syntax:

SET CONSTRAINTS command:

Syntax:

SET TRANSACTION command:

Syntax:

SHOW command:

Syntax:

START TRANSACTION:

Syntax:

TRUNCATE TABLE command:

Syntax:

UPDATE command:

Syntax:






Latest Courses