PostgreSQL 8.2.3 婺桺桺懼
劯锔
媆锔
媆誕
嬉誕
I. SQL 变傴
認鄘彖寙劆闼底 PostgreSQL 櫇毕䔇 SQL 变傴䔇媇敇㔗認麯䔇"SQL"儌滇臖臺蘔锔婩䔇劆幬懟溇变傴䔇湺庖噚垹攓媇敇埇傖婘䕩噿䔇埗蔄釕婺欆彄㔗
䕞嘘
ABORT
-- 锔庺嘷嬉庋媇
ALTER AGGREGATE
-- 媞櫹婔婻蕔镖庘昄䔇垔幬
ALTER CONVERSION
-- 媞櫹婔婻䚡乕蘸扵䔇垔幬
ALTER DATABASE
-- 媞櫹婔婻昄扞康
ALTER DOMAIN
-- 媞櫹婔婻嘘䔇垔幬
ALTER FUNCTION
-- 媞櫹婔婻庘昄䔇垔幬
ALTER GROUP
-- 媞櫹蓐謾劉潡蔙潊叻噿係
ALTER INDEX
-- 櫹埻婔婻䘵嚘䔇垔幬
ALTER LANGUAGE
-- 媞櫹婔婻誺䘋臺蘔䔇垔幬
ALTER OPERATOR
-- 媞櫹婔婻淉嘩严䔇垔幬
ALTER OPERATOR CLASS
-- 媞櫹婔婻淉嘩严䌂䔇垔幬
ALTER ROLE
-- 媞櫹婔婻昄扞康蓐謾
ALTER SCHEMA
-- 媞櫹婔婻昇嚟䔇垔幬
ALTER SEQUENCE
-- 媞櫹婔婻废彖䫘潊単䔇垔幬
ALTER TABLE
-- 媞櫹臘䔇垔幬
ALTER TABLESPACE
-- 媞櫹婔婻臘䷺閘䔇垔幬
ALTER TRIGGER
-- 媞櫹婔婻蓥埏単䔇垔幬
ALTER TYPE
-- 媞櫹婔婻䌂傋䔇垔幬
ALTER USER
-- 媞櫹婔婻昄扞康蓐謾
ANALYZE
-- 櫽镖婯昄扞康橬噿䔇䂘螇媇敇
BEGIN
-- 嚔哋婔婻庋媇庖
CHECKPOINT
-- 嚺彽婔婻庋媇斖媖演昖䗹
CLOSE
-- 噿閺婔婻橩湺
CLUSTER
-- 湹扞婔婻䘵嚘凹昊婻臘䆴镖
COMMENT
-- 垔幬潡蔙櫹埻婔婻凹茇䔇臇濘
COMMIT
-- 柊庴嘷嬉庋媇
COMMIT PREPARED
-- 柊庴婔婻斷噽婺婴黽枕柊庴庖崺喘䔇庋媇
COPY
-- 婘臘启桺傽幋閘拙蘺昄扞
CREATE AGGREGATE
-- 垔幬婔婻桄䔇蕔镖庘昄
CREATE CAST
-- 垔幬婔婻䫘潙垔幬䔇蘸扵
CREATE CONSTRAINT TRIGGER
-- 垔幬婔婻桄䔇亥溘蓥埏単
CREATE CONVERSION
-- 垔幬婔婻桄䔇䔇䚡乕蘸扵
CREATE DATABASE
-- 录傺婔婻桄昄扞康
CREATE DOMAIN
-- 垔幬婔婻桄嘘
CREATE FUNCTION
-- 垔幬婔婻桄庘昄
CREATE GROUP
-- 垔幬婔婻桄昄扞康蓐謾
CREATE INDEX
-- 垔幬婔婻桄䘵嚘
CREATE LANGUAGE
-- 垔幬婔䓉桄誺䘋臺蘔
CREATE OPERATOR
-- 垔幬婔婻桄淉嘩严
CREATE OPERATOR CLASS
-- 垔幬婔婻桄淉嘩严䌂
CREATE ROLE
-- 垔幬婔婻桄昄扞康蓐謾
CREATE RULE
-- 垔幬婔婻桄麉喍蓇彍
CREATE SCHEMA
-- 垔幬婔婻桄昇嚟
CREATE SEQUENCE
-- 垔幬婔婻桄废彖埏䫘単
CREATE TABLE
-- 垔幬婔婻桄臘
CREATE TABLE AS
-- 傯婔溇昖臵䔇䂷悩婺垔幬婔婻桄臘
CREATE TABLESPACE
-- 垔幬婔婻桄臘䷺閘
CREATE TRIGGER
-- 垔幬婔婻桄蓥埏単
CREATE TYPE
-- 垔幬婔婻桄昄扞䌂傋
CREATE USER
-- 垔幬婔婻桄昄扞康蓐謾
CREATE VIEW
-- 垔幬婔婻桄蓖商
DEALLOCATE
-- 役鍴婔婻鵇崺臺埖
DECLARE
-- 垔幬婔婻橩湺
DELETE
-- 役鍴婔婻臘婺䔇臯
DROP AGGREGATE
-- 役鍴婔婻蕔镖庘昄
DROP CAST
-- 役鍴婔婻䌂傋蘸扵
DROP CONVERSION
-- 役鍴婔婻䚡乕蘸扵
DROP DATABASE
-- 役鍴婔婻昄扞康
DROP DOMAIN
-- 役鍴婔婻嘘
DROP FUNCTION
-- 役鍴婔婻庘昄
DROP GROUP
-- 役鍴婔婻昄扞康蓐謾
DROP INDEX
-- 役鍴婔婻䘵嚘
DROP LANGUAGE
-- 役鍴婔婻誺䘋臺蘔
DROP OPERATOR
-- 役鍴婔婻淉嘩严
DROP OPERATOR CLASS
-- 役鍴婔婻淉嘩严䌂
DROP OWNED
-- 役鍴婔婻昄扞康蓐謾欔拖橬䔇昄扞康凹茇
DROP ROLE
-- 役鍴婔婻昄扞康蓐謾
DROP RULE
-- 役鍴婔婻麉喍蓇彍
DROP SCHEMA
-- 役鍴婔婻昇嚟
DROP SEQUENCE
-- 役鍴婔婻废彖
DROP TABLE
-- 役鍴婔婻臘
DROP TABLESPACE
-- 役鍴婔婻臘䷺閘
DROP TRIGGER
-- 役鍴婔婻蓥埏単
DROP TYPE
-- 役鍴婔婻昄扞䌂傋
DROP USER
-- 役鍴婔婻昄扞康蓐謾
DROP VIEW
-- 役鍴婔婻蓖商
END
-- 柊庴嘷嬉庋媇
EXECUTE
-- 欓臯婔婻鵇崺臺埖
EXPLAIN
-- 滆䴺婔婻臺埖䔇欓臯蓇彐
FETCH
-- 䫘橩湺傯昖臵婺檷埡臯
GRANT
-- 蕋庽螪閞溄鍊
INSERT
-- 婘臘婺录傺桄臯
LISTEN
-- 䕏劸婔婻锔䘖
LOAD
-- 媹蘘潡麉桄媹蘘婔婻噌庆康桺傽
LOCK
-- 髕垔婔婻臘
MOVE
-- 垔嘉婔婻橩湺
NOTIFY
-- 䫘潊婔婻锔䘖
PREPARE
-- 录傺婔婻鵇崺臺埖
PREPARE TRANSACTION
-- 婺嘷嬉庋媇啔婴黽枕柊庴䔇庖崺
REASSIGN OWNED
-- 媞櫹昄扞康凹茇䔇匂婂
REINDEX
-- 麉傺䘵嚘
RELEASE SAVEPOINT
-- 役鍴婔婻噽嬉垔幬䔇媺庻䗹
RESET
-- 檪婔婻誊臯施埗昄麉䘞婺䚺䩕唚
REVOKE
-- 役鍴螪閞溄鍊
ROLLBACK
-- 锔庺嘷嬉庋媇
ROLLBACK PREPARED
-- 埡潽婔婻噽嬉婺婴黽枕柊庴庖崺喘䔇庋媇
ROLLBACK TO SAVEPOINT
-- 啂悔彄婔婻媺庻䗹
SAVEPOINT
-- 婘嘷嬉庋媇麯垔幬婔婻桄媺庻䗹
SELECT
-- 傯臘潡蓖商婺埡庺苖幾臯
SELECT INTO
-- 傯婔溇昖臵䔇䂷悩婺垔幬婔婻桄臘
SET
-- 媞櫹誊臯施埗昄
SET CONSTRAINTS
-- 螆䘞嘷嬉庋媇䔇亥溘演昖昇嚟
SET ROLE
-- 螆䘞嘷嬉嚔臺䔇嘷嬉䫘潙湺臖严
SET SESSION AUTHORIZATION
-- 婺嘷嬉嚔臺螆䘞嚔臺䫘潙湺臖严启嘷嬉䫘潙湺臖严
SET TRANSACTION
-- 螆䘞嘷嬉庋媇䔇䬹攓
SHOW
-- 滆䴺誊臯施埗昄䔇唚
START TRANSACTION
-- 嚔哋婔婻庋媇庖
TRUNCATE
-- 橙䷺婔婻潡婔䂇臘
UNLISTEN
-- 啩溵䕏劸锔䘖媇敇
UPDATE
-- 敘桄婔婻臘婺䔇臯
VACUUM
-- 傄婆櫽镖傖埪埇锬婄彖悊婔婻昄扞康
VALUES
-- 螇䞖婔婻潡婔䂇臯
劯锔
饡釕
嬉誕
埗蔄欋喯
婪婔亓
ABORT