Table of Commands

I l @ ve RuBoard

The following table organizes the supported SQL commands by task.

 

Creation

Destruction

Use/Modify

Database

CREATE DATABASE

DROP DATABASE

COMMENT

LOAD

VACUUM

Table/Index

CREATE TABLE

CREATE INDEX

CREATE VIEW

DROP TABLE

DROP INDEX

DROP VIEW

TRUNCATE

COMMENT

SELECT

EXPLAIN

ALTER TABLE

ALTER INDEX

COPY

UPDATE

INSERT

DELETE

SELECT INTO

VACUUM

CLUSTER

Constraints

CREATE TRIGGER

CREATE CONSTRAINT

CREATE RULE

CREATE SEQUENCE

DROP TRIGGER

DROP CONSTRAINT

DROP RULE

DROP SEQUENCE

COMMENT

User

CREATE USER

CREATE GROUP

DROP USER

DROP GROUP

ALTER USER

ALTER GROUP

GRANT

REVOKE

Session/Transaction

SET

DECLARE

BEGIN

CLOSE

ABORT

COMMIT

ROLLBACK

END

SHOW

RESET

FETCH

MOVE

LISTEN

UNLISTEN

NOTIFY

LOCK

UNLOCK

Misc

CREATE AGGREGATE

CREATE OPERATOR

CREATE TYPE

CREATE LANGUAGE

CREATE FUNCTION

DROP AGGREGATE

DROP OPERATOR

DROP TYPE

DROP LANGUAGE

DROP FUNCTION

COMMENT

I l @ ve RuBoard


PostgreSQL Essential Reference
PostgreSQL Essential Reference
ISBN: 0735711216
EAN: 2147483647
Year: 2001
Pages: 118
Authors: Barry Stinson

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net