SQL tutorial for PostgreSQL
top of page
CerebroSQL

Справочник команд для PostgreSQL

Описание синтаксиса SQL и команд DDL поддерживаемых СУБД PostgreSQL с примерами использования.

 

ALTER AGGREGATE

ALTER COLLATION

ALTER CONVERSION

ALTER DATABASE

ALTER DEFAULT PRIVILEGES

ALTER EVENT TRIGGER

ALTER EXTENSION

ALTER FOREIGN DATA WRAPPER

ALTER FOREIGN TABLE

ALTER FOREIGN TABLE

ALTER FUNCTION

ALTER LANGUAGE

ALTER LARGE OBJECT

ALTER MATERIALIZED VIEW

ALTER OPERATOR

ALTER OPERATOR CLASS

ALTER OPERATOR FAMILY

ALTER SEQUENCE

ALTER TABLESPACE

ALTER TEXT SEARCH CONFIGURATION

ALTER TEXT SEARCH DICTIONARY

ALTER TEXT SEARCH PARSER

ALTER TEXT SEARCH TEMPLATE

ALTER TRIGGER

ALTER USER MAPPING

COMMIT PREPARED

CREATE ACCESS METHOD

CREATE AGGREGATE

CREATE COLLATION

CREATE CONVERSION

CREATE DATABASE

CREATE EVENT TRIGGER

CREATE EXTENSION

CREATE FOREIGN DATA WRAPPER

CREATE FOREIGN TABLE

CREATE FUNCTION

CREATE LANGUAGE

CREATE MATERIALIZED VIEW

CREATE OPERATOR

CREATE OPERATOR CLASS

CREATE OPERATOR FAMILY

CREATE POLICY

CREATE SCHEMA

CREATE SEQUENCE

CREATE SERVER

CREATE TABLE AS

CREATE TABLESPACE

CREATE TEXT SEARCH CONFIGURATION

CREATE TEXT SEARCH DICTIONARY

CREATE TEXT SEARCH PARSER

CREATE TEXT SEARCH TEMPLATE

CREATE TRANSFORM

CREATE TRIGGER

CREATE USER MAPPING

DROP ACCESS METHOD

DROP AGGREGATE

DROP COLLATION

DROP CONVERSION

DROP DATABASE

DROP EVENT TRIGGER

DROP EXTENSION

DROP FOREIGN DATA WRAPPER

DROP FOREIGN TABLE

DROP FUNCTION

DROP LANGUAGE

DROP MATERIALIZED VIEW

DROP OPERATOR

DROP OPERATOR CLASS

DROP OPERATOR FAMILY

DROP SEQUENCE

DROP TABLESPACE

DROP TEXT SEARCH CONFIGURATION

DROP TEXT SEARCH DICTIONARY

DROP TEXT SEARCH PARSER

DROP TEXT SEARCH TEMPLATE

DROP TRANSFORM

DROP USER MAPPING

IMPORT FOREIGN SCHEMA

PREPARE TRANSACTION

REASSIGN OWNED

REFRESH MATERIALIZED VIEW

RELEASE SAVEPOINT

ROLLBACK PREPARED

ROLLBACK TO SAVEPOINT

SECURITY LABEL

SET CONSTRAINTS

SET SESSION AUTHORIZATION

SET TRANSACTION

START TRANSACTION

bottom of page