Javatpoint Logo
Javatpoint Logo

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:





Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA