PostgreSQL 7.1.1 ²Î¿¼ÊÖ²á

The PostgreSQL Global Development Group


Table of Contents
I. SQL ÃüÁî
ABORT — Í˳öµ±Ç°ÊÂÎñ
ALTER GROUP — Ïò×éÖÐÔö¼ÓÓû§»òɾ³ýÓû§
ALTER TABLE — ¸ü¸Ä±íÊôÐÔ
ALTER USER — ¸ü¸ÄÓû§ÕÊ»§ÐÅÏ¢£®
BEGIN — ÒÔÁ´»·Ä£Ê½¿ªÊ¼Ò»¸öÊÂÎñ
CHECKPOINT — Ç¿ÖÆÊÂÎñÈÕÖ¾¼ì²éµã
CLOSE — ¹Ø±ÕÒ»¸öÓαê
CLUSTER — Ïò·þÎñÆ÷¸ø³ö´æ´¢½¨´ØµÄ½¨Òé
COMMENT — ¸øÒ»¸ö¶ÔÏóÔö¼ÓÆÀ×¢
COMMIT — Ìá½»µ±Ç°ÊÂÎñ
COPY — ÔÚ±íºÍÎļþÖ®¼ä¿½±´Êý¾Ý
CREATE AGGREGATE — ¶¨ÒåÒ»¸öеľۼ¯º¯Êý
CREATE CONSTRAINT TRIGGER — ´´½¨Ò»¸ö´¥·¢Æ÷ÒÔÖ§³ÖÒ»¸öÔ¼Êø£®
CREATE DATABASE — ´´½¨ÐÂÊý¾Ý¿â
CREATE FUNCTION — ¶¨ÒåÒ»¸öк¯Êý
CREATE GROUP — ´´½¨Ò»¸öÐÂ×é
CREATE INDEX — ¹¹ÔìÒ»¸ö´ÓË÷Òý
CREATE LANGUAGE — Ϊº¯Êý¶¨ÒåÒ»¸öеÄÓïÑÔ
CREATE OPERATOR — ¶¨ÒåÒ»¸öеÄÓû§²Ù×÷·û
CREATE RULE — ¶¨ÒåÒ»¸öйæÔò
CREATE SEQUENCE — ´´½¨Ò»¸öеÄÐòÁкÅÉú³ÉÆ÷
CREATE TABLE — ´´½¨Ò»¸öбí
CREATE TABLE AS — ´ÓÒ»Ìõ SELECT µÄ½á¹ûÖд´½¨Ò»¸öбí
CREATE TRIGGER — ´´½¨Ò»¸öд¥·¢Æ÷
CREATE TYPE — ¶¨ÒåÒ»¸öеĻù±¾Êý¾ÝÀàÐÍ
CREATE USER — ´´½¨Ò»¸öеÄÊý¾Ý¿âÓû§
CREATE VIEW — ¹¹ÔìÒ»¸öÐéÄâ±í£¨ÊÓͼ£©
DECLARE — Ϊ·ÃÎÊ±í¶¨ÒåÒ»¸öÓαê
DELETE — ´Ó±íÖÐɾ³ýÐÐ
DROP AGGREGATE — ɾ³ýÒ»¸ö¾Û¼¯º¯ÊýµÄ¶¨Òå
DROP DATABASE — ɾ³ýÒ»¸öÏÖÓÐÊý¾Ý¿â£®
DROP FUNCTION — ɾ³ýÒ»¸öÓû§¶¨ÒåµÄ C º¯Êý
DROP GROUP — ɾ³ýÒ»¸ö×é
DROP INDEX — ´ÓÒ»¸öÊý¾Ý¿âɾ³ýÏÖÓÐË÷Òý
DROP LANGUAGE — ɾ³ýÒ»¸öÓû§¶¨ÒåµÄ¹ý³ÌÓïÑÔ
DROP OPERATOR — ´ÓÊý¾Ý¿âÖÐɾ³ýÒ»¸ö²Ù×÷·û
DROP RULE — ´ÓÊý¾Ý¿âÖÐɾ³ýÒ»¸öÏÖ´æµÄ¹æÔò
DROP SEQUENCE — ´ÓÊý¾Ý¿âÖÐɾ³ýÒ»¸öÏÖ´æµÄÐòÁÐ
DROP TABLE — ´ÓÊý¾Ý¿âÖÐɾ³ýÒ»¸öÏÖ´æ±í
DROP TRIGGER — ɾ³ýÒ»¸ö´¥·¢Æ÷¶¨Ò壮
DROP TYPE — ´Óϵͳ±íÀïɾ³ýÒ»¸öÓû§¶¨ÒåÀàÐÍ
DROP USER — ɾ³ýÒ»¸öÓû§
DROP VIEW — ´ÓÊý¾Ý¿âÖÐɾ³ýÒ»¸öÏÖ´æµÄÊÓͼ
END — Ìá½»µ±Ç°µÄÊÂÎñ
EXPLAIN — ÏÔʾÓï¾äÖ´Ðй滮
FETCH — ÓÃÓαê»ñÈ¡ÐÐ
GRANT — ¸³ÓèÒ»¸öÓû§£¬Ò»¸ö×é»òËùÓÐÓû§·ÃÎÊȨÏÞ
INSERT — Ïò±íÖвåÈëÐÂÐÐ
LISTEN — ¼àÌýÒ»¸ö֪ͨÌõ¼þµÄÏìÓ¦ÐÅÏ¢
LOAD — ¶¯Ì¬×°ÔØÒ»¸ö¶ÔÏóÎļþ
LOCK — ÔÚÊÂÎñÖÐÃ÷È·µØËø¶¨Ò»¸ö±í
MOVE — Òƶ¯ÓαêµÄλÖÃ
NOTIFY — ֪ͨËùÓÐÕýÔÚ¼àÌýij¸ö֪ͨÌõ¼þµÄÇ°¶ËºÍºó¶Ë
REINDEX — ÔÚÒ»¸ö¶À×ÔÔËÐУ¨Ã»ÓÐÁª½Ó£©µÄ Postgres Éϻָ´»Ù»µÁ˵ÄϵͳË÷Òý
RESET — °Ñ»á»°µÄÔËÐÐʱ²ÎÊýÉèΪȱʡֵ
REVOKE — ·Ï³ýijÓû§»òij×é»òËùÓÐÓû§·ÃÎÊȨÏÞ£®
ROLLBACK — Í˳öµ±Ç°ÊÂÎñ
SELECT — ´Ó±í»òÊÓͼÖÐÈ¡³öÈô¸ÉÐУ®
SELECT INTO — ´Óµ±Ç°±í»òÊÓͼÖд´½¨Ò»¸öбí
SET — ÉèÖÃÔËÐÐʱ²ÎÊý
SET CONSTRAINTS — ÉèÖõ±Ç°SQLÊÂÎñµÄÔ¼Êøģʽ
SET TRANSACTION — ÉèÖõ±Ç°SQLÊÂÎñµÄÌØÐÔ
SHOW — ÏÔʾÔËÐÐʱ²ÎÊý
TRUNCATE — Çå¿ÕÒ»¸ö±í
UNLISTEN — Í£Ö¹¼àÌý֪ͨÐÅÏ¢
UPDATE — Ìæ»»±íÖÐÁÐ/×ֶεÄÊýÖµ
VACUUM — ÇåÀíºÍ·ÖÎöPostgres Êý¾Ý¿â
II. ¿Í»§¶ËÓ¦ÓÃ
createdb — ´´½¨Ò»¸öÐ嵀 Postgres Êý¾Ý¿â
createuser — ´´½¨Ò»¸öÐ嵀 Postgres Óû§
dropdb — ɾ³ýÒ»¸öÏÖÓÐ Postgres Êý¾Ý¿â
dropuser — ɾ³ýÒ»¸ö Postgres Óû§
ecpg — ǶÈëµÄ SQL C Ô¤´¦ÀíÆ÷
pgaccessPostgres ͼÐλ¯½»»¥¿Í»§¶Ë
pgadmin — ÔËÐÐÔÚ Windows 95/98/NT ƽ̨É쵀 Postgres Êý¾Ý¿â¹ÜÀíºÍÉè¼Æ¹¤¾ß¡£
pg_config — ÌṩÒÑ°²×°°æ±¾µÄ PostgreSQL µÄÐÅÏ¢
pg_dump — ½«Ò»¸öPostgresÊý¾Ý¿â³é³öµ½Ò»¸ö½Å±¾Îļþ »òÕßÆäËüµÄ¹éµµÎļþÖÐ
pg_dumpall — ³é³öËùÓÐ Postgres Êý¾Ý¿âµ½½Å±¾ÎļþÖС£
pg_restore — ´ÓÒ»¸öÓÉ pg_dump ´´½¨µÄ±¸·ÝÎļþÖлָ´ Postgres Êý¾Ý¿â£®
psqlPostgres ½»»¥ÖÕ¶Ë
pgtclshPostgreSQL TCL shell ¿Í»§¶Ë
pgtkshPostgreSQL Tcl/Tk shell ¿Í»§¶Ë£®
vacuumdb — ÇåÀíºÍ·ÖÎöÒ»¸öPostgres Êý¾Ý¿â
III. PostgreSQL ·þÎñÆ÷Ó¦ÓÃ
createlang — Ïò PostgresÊý¾Ý¿âÔö¼ÓÒ»ÖÖеıà³ÌÓïÑÔ
droplang — ´ÓÒ»¸ö Postgres Êý¾Ý¿âÀïɾ³ýÒ»ÖÖ±à³ÌÓïÑÔ
initdb — ´´½¨Ò»¸öÐ嵀 PostgresÊý¾Ý¿â½Úµã
initlocation — ´´½¨Ò»¸ö´ÓÊôµÄ PostgresÊý¾Ý¿â´æ´¢Çø
ipcclean — ÇåÀíÍ˳öµÄºó¶ËÁôÏµĹ²ÏíÄÚ´æºÍÐźŵÆ
pg_ctl — Æô¶¯£¬Í£Ö¹ºÍÖØÆð postmaster
pg_passwd — ²Ù×÷ƽÃæ¿ÚÁîÎļþ
postgres — ÔËÐÐÒ»¸ö Postgresµ¥Óû§ºó¶Ë
postmasterPostgreSQL¶àÓû§Êý¾Ý¿â·þÎñÆ÷