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 — Í¨ÖªËùÓÐÕýÔÚ¼àÌýÄ³¸öÍ¨ÖªÌõ¼þµÄÇ°¶ËºÍºó¶Ë
REINDEX — ÔÚÒ»¸ö¶À×ÔÔËÐÐ£¨Ã»ÓÐÁª½Ó£©µÄ Postgres ÉÏ»Ö¸´»Ù»µÁËµÄÏµÍ³Ë÷Òý
RESET — °Ñ»á»°µÄÔËÐÐÊ±²ÎÊýÉèÎªÈ±Ê¡Öµ
REVOKE — ·Ï³ýÄ³ÓÃ»§»òÄ³×é»òËùÓÐÓÃ»§·ÃÎÊÈ¨ÏÞ£®
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 Ô¤´¦ÀíÆ÷
pgaccess — Postgres Í¼ÐÎ»¯½»»¥¿Í»§¶Ë
pgadmin — ÔËÐÐÔÚ Windows 95/98/NT Æ½Ì¨ÉÏµÄ Postgres Êý¾Ý¿â¹ÜÀíºÍÉè¼Æ¹¤¾ß¡£
pg_dump — ½«Ò»¸öPostgresÊý¾Ý¿â³é³öµ½Ò»¸ö½Å±¾ÎÄ¼þ »òÕßÆäËüµÄ¹éµµÎÄ¼þÖÐ
pg_dumpall — ³é³öËùÓÐ Postgres Êý¾Ý¿âµ½½Å±¾ÎÄ¼þÖÐ¡£
pg_restore — ´ÓÒ»¸öÓÉ pg_dump ´´½¨µÄ±¸·ÝÎÄ¼þÖÐ»Ö¸´ Postgres Êý¾Ý¿â£®
psql — Postgres ½»»¥ÖÕ¶Ë
pgtclsh — PostgreSQL TCL shell ¿Í»§¶Ë
pgtksh — PostgreSQL Tcl/Tk shell ¿Í»§¶Ë£®
vacuumdb — ÇåÀíºÍ·ÖÎöÒ»¸öPostgres Êý¾Ý¿â

III. PostgreSQL ·þÎñÆ÷Ó¦ÓÃ

createlang — Ïò PostgresÊý¾Ý¿âÔö¼ÓÒ»ÖÖÐÂµÄ±à³ÌÓïÑÔ
droplang — ´ÓÒ»¸ö Postgres Êý¾Ý¿âÀïÉ¾³ýÒ»ÖÖ±à³ÌÓïÑÔ
initdb — ´´½¨Ò»¸öÐÂµÄ PostgresÊý¾Ý¿â½Úµã
initlocation — ´´½¨Ò»¸ö´ÓÊôµÄ PostgresÊý¾Ý¿â´æ´¢Çø
ipcclean — ÇåÀíÍË³öµÄºó¶ËÁôÏÂµÄ¹²ÏíÄÚ´æºÍÐÅºÅµÆ
pg_ctl — Æô¶¯£¬Í£Ö¹ºÍÖØÆð postmaster
pg_passwd — ²Ù×÷Æ½Ãæ¿ÚÁîÎÄ¼þ
postgres — ÔËÐÐÒ»¸ö Postgresµ¥ÓÃ»§ºó¶Ë
postmaster — PostgreSQL¶àÓÃ»§Êý¾Ý¿â·þÎñÆ÷

Prev	Home	Next
Ê¹ÓÃ PL/Perl		SQL ÃüÁî