PostgreSQL

The PostgreSQL Development Team

Edited by

Thomas Lockhart

PostgreSQLis Copyright ?1996-2000 by PostgreSQL Inc.

±àÒ룺ºÎΰƽ  laser@zhengmai.com.cn

ÖÐÎÄÒë¸å°æȨÉùÃ÷£º

±¾ÎĵÄÖÐÎÄÒë¸å°æȨÊôÓÚÆäÖÐÎÄÒë¸å×÷Õß¡£Äú¿É¶Ô±¾ÊÖ²á½øÐзÇÉÌÒµÓÃ;µÄ×ÔÓÉ´«²¥£¬µ«Îñ±Ø±£Ö¤ÊÖ²áµÄÍêÕûÐÔ£¬×ªÔØʱÇë±£Áô±¾°æȨÉùÃ÷£®ÓÉÓÚÒëÕßˮƽÓÐÏÞ£¬´íÎóÖ®´¦ÔÚËùÄÑÃ⣬ϣÍû¸÷λÓû§Ö¸Õý£®ÓÉ´Ë´øÀ´µÄÒ»Çкó¹û£¬±¾È˸Ų»¸ºÔð£®


ÄÚÈÝ
ÕªÒª
I. Óû§ÊÖ²á
1. ¼ò½é
ºÎΪ Postgres£¿
¼òµ¥»Ø¹Ë Postgres
¹ØÓÚÕâ¸ö°æ±¾
×ÊÔ´
ÊõÓï
·ûºÅ
ÎÊÌâ»ã±¨Ö¸µ¼
Y2K ÉùÃ÷
°æȨºÍÉ̱ê
2. SQL Óï·¨
¹Ø¼ü×Ö
×¢ÊÍ
Ãû³Æ
³£Á¿
ÓòºÍÁУ¨×ֶΣ©
²Ù×÷·û
±í´ïʽ
3. Êý¾ÝÀàÐÍ
ÊýÖµÀàÐÍ
»õ±ÒÀàÐÍ
×Ö·ûÀàÐÍ
ÈÕÆÚ/ʱ¼äÀàÐÍ
²¼¶ûÀàÐÍ
¼¸ºÎÀàÐÍ
IP °æ±¾ 4 ÍøÂçºÍÖ÷»úµØÖ·
4. ²Ù×÷·û
Óï·¨ÓÅÏȼ¶
ͨÓòÙ×÷·û
Êý×Ö²Ù×÷·û
¼¸ºÎ²Ù×÷·û
ʱ¼ä¼ä¸ô²Ù×÷·û
IP V4 CIDR ²Ù×÷·û
IP V4 INET ²Ù×÷·û
5. º¯Êý
SQL º¯Êý
Êýѧº¯Êý
×Ö·û´®º¯Êý
ÈÕÆÚ/ʱ¼äº¯Êý
¸ñʽ»¯º¯Êý
¼¸ºÎº¯Êý
IP V4 º¯Êý
6. ÀàÐÍת»»
¸ÅÊö
²Ù×÷·û
º¯Êý
²éѯĿ±ê
UNION ²éѯ
7. Ë÷ÒýºÍ¼ü×Ö
¼ü×Ö
²¿·ÖË÷Òý
8. Êý×é
9. ¼Ì³Ð
10. PL/pgSQL - SQL ¹ý³ÌÓïÑÔ
¸ÅÊö
ÃèÊö
Àý×Ó
11. PL/Tcl - TCL ¹ý³ÌÓïÑÔ
¸ÅÊö
ÃèÊö
12. PL/perl - Perl ¹ý³ÌÓïÑÔ
¸ÅÊö
ÖÆ×÷ºÍ°²×°
ʹÓà PL/Perl
13. ¶à°æ±¾²¢ÐпØÖÆ
½éÉÜ
ÊÂÎñ¸ôÀë
¶ÁÒÑÌá½»¸ôÀ뼶±ð
¿É´®Ðл¯¸ôÀ뼶±ð
迼걒
ËøºÍË÷Òý
Ó¦ÓòãµÄÊý¾ÝÍêÕûÐÔ¼ì²é
14. ÉèÖÃÔËÐл·¾³
15. ¹ÜÀíÊý¾Ý¿â
´´½¨Êý¾Ý¿â
±ä»»Êý¾Ý¿âλÖÃ
·ÃÎÊÊý¾Ý¿â
ɾ³ýÊý¾Ý¿â
16. ´ÅÅÌ´æ´¢
17. Àí½âÐÔÄÜ
ʹÓà EXPLAIN
18. ÏòÊý¾Ý¿âÌí¼Ó¼Ç¼
¹Ø±Õ×Ô¶¯Ìá½»
ʹÓà COPY FROM
ɾ³ýË÷Òý
19. SQL ÃüÁî
ABORT - Í˳öµ±Ç°ÊÂÎñ
ALTER GROUP - Ïò×éÖÐÔö¼ÓÐÂÓû§£¬´Ó×éÖÐɾ³ýÓû§
ALTER TABLE - Ð޸ıíÊôÐÔ
ALTER USER - ÐÞ¸ÄÓû§ÕÊ»§ÐÅÏ¢
BEGIN - ÒÔÁ´Ä£Ê½¿ªÊ¼Ò»¸öÊÂÎñ
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 - ´´½¨Ò»¸öбí
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 -·Ï³ýÒ»¸öÓû§£¬Ò»¸ö×é»òÕßËùÓÐÓû§µÄ·ÃÎÊȨÏÞ
ROLLBACK - Í˳öµ±Ç°µÄÊÂÎñ
SELECT -´ÓÒ»¸ö±í»òÕßÊÓͼÀï¼ìË÷ÐÐ
SELECT INTO - ´ÓÒ»¸öÏÖÓеıí»òÕßÊÓͼÀï´´½¨Ð±í
SET - Ϊ»á»°ÉèÖÃÔËÐÐʱ²ÎÊý
SHOW - Ϊ»á»°ÏÔʾÔËÐÐʱ²ÎÊý
TRUNCATE - Çå¿ÕÒ»¸ö±í
UNLISTEN - ֹ֪ͣͨÌõ¼þµÄÕìÌý
UPDATE - µ÷»»Ò»¸ö±íÀïijÐеÄ×ֶεÄÖµ
VACUUM - ÇåÀíºÍ·ÖÎöÒ»¸ö Postgres Êý¾Ý¿â
20. Ó¦ÓÃ
createdb - ´´½¨Ò»¸öеĠPostgres Êý¾Ý¿â
createlang - ÏòÒ»¸ö Postgres Êý¾Ý¿âÀïÔö¼ÓÒ»ÃÅеıà³ÌÓïÑÔ
createuser - ´´½¨Ò»¸öеĠPostgres Óû§
dropdb - ɾ³ýÒ»¸öÏÖ´æ Postgres Êý¾Ý¿â
droplang - ´ÓÒ»¸ö Postgres Êý¾Ý¿âÀïɾ³ýÒ»Ãűà³ÌÓïÑÔ
dropuser - ɾ³ýÒ»¸ö Postgres Óû§
ecpg - ǶÈëµÄ SQL C Ô¤±àÒëÆ÷
pgaccess -Postgres ͼÐλ¯½»»¥¿Í»§¶Ë
pgadminPostgres ÓÃÓÚ  Windows 95/98/NT  ƽ̨µÄÊý¾Ý¿â¹ÜÀíºÍÉè¼Æ¹¤¾ß
pg_ctl - Æô¶¯£¬Í£Ö¹¡¡ºÍÖØÐÂÆô¶¯ postmaster
pg_dump - °ÑÒ»¸ö Postgres Êý¾Ý¿â³é³öµ½Ò»¸ö½Å±¾ÎļþÀï
pg_dumpall - °ÑËùÓРPostgres Êý¾Ý¿â³é³öµ½Ò»¸ö½Å±¾ÎļþÀï
psqlPostgres ½»»¥µÄÖÕ¶Ë
pgtclshPostgres TCL shell ¿Í»§¶Ë
pgtkshPostgres ͼÐλ¯µÄ TCL/TK shell
vacuumdb - ÇåÀíºÍ·ÖÎöÒ»¸ö Postgres Êý¾Ý¿â
21. ϵͳӦÓÃ
initdb -  ´´½¨Ò»¸öеĠPostgres Êý¾Ý¿â°²×°
initlocation - ´´½¨Ò»¸ö´ÓÊôµÄ Postgres Êý¾Ý¿â´æ´¢Çø
ipcclean - ΪÍ˳öµÄºó¶ËÉèÖù²ÏíÄÚ´æºÍÐźŵÆ
pg_passwd - ¹ÜÀíƽÃæ¿ÚÁîÎļþ
pg_upgrade - ÔÊÐí²»ÖØÐÂ×°ÔØÊý¾Ý´ÓÇ°Ãæ°æ±¾Éý¼¶
postgres - ÔËÐÐÒ»¸ö Postgres µ¥Óû§ºó¶Ë
postmaster - ÔËÐРPostgres ¶àÓû§ºó¶Ë
II. ¹ÜÀíÔ±ÊÖ²á
22. ÒÆÖ²
Ä¿Ç°Ö§³ÖµÄƽ̨
²»Ö§³ÖµÄƽ̨
23. ÅäÖÃÑ¡Ïî
ÅäÖòÎÊý £¨configure£©
ÖÆ×÷²ÎÊý£¨make£©
±¾µØ»¯Ö§³Ö
Kerberos ÈÏÖ¤
24. ϵͳ²¼¾Ö
25. °²×°
°²×°Ö®Ç°
°²×°¹ý³Ì
26. ÔÚ Win32 ÉÏ°²×°
ÖÆ×÷¿â
°²×°¿â
ʹÓÿâ
27. ÔËÐÐʱ»·¾³
ÔÚ Unix ÀïʹÓàPostgres
Æô¶¯ postmaster
ʹÓà pg_options
28. °²È«ÐÔ
Óû§ÈÏÖ¤
Óû§ÃûºÍ×é
·ÃÎÊ¿ØÖÆ
º¯ÊýºÍ¹æÔò
°²È« TCP/IP Áª½Ó
29. Ìí¼ÓºÍɾ³ýÓû§
30. ´ÅÅ̹ÜÀí
¸Ä±ä£¨´æ´¢£©Î»ÖÃ
31. ¹ÜÀíÊý¾Ý¿â
´´½¨Êý¾Ý¿â
·ÃÎÊÊý¾Ý¿â
ɾ³ýÊý¾Ý¿â
±¸·ÝºÍ»Ö¸´
32. Íɱä²âÊÔ
Postmaster Æô¶¯Ê§°Ü
¿Í»§¶ËÁª½ÓÎÊÌâ
µ÷ÊÔÐÅÏ¢
33. Êý¾Ý¿â»Ö¸´
34. Íɱä²âÊÔ
Íɱä²âÊÔ»·¾³
Íɱä²âÊÔ¹ý³Ì
Íɱä·ÖÎö
ƽ̨Ïà¹ØµÄ±È½ÏÎļþ
35. °æ±¾ÐÅÏ¢
°æ±¾ 7.0
°æ±¾ 6.5.3
°æ±¾ 6.5.2
°æ±¾ 6.5.1
°æ±¾ 6.5
°æ±¾ 6.4.2
°æ±¾ 6.4.1
°æ±¾ 6.4
°æ±¾ 6.3.2
°æ±¾ 6.3.1
°æ±¾ 6.3
°æ±¾ 6.2.1
°æ±¾ 6.2
°æ±¾ 6.1.1
°æ±¾ 6.1
°æ±¾ v6.0
°æ±¾ v1.09
°æ±¾ v1.02
°æ±¾ v1.01
°æ±¾ v1.0
Postgres95 Beta 0.03
Postgres95 Beta 0.02
Postgres95 Beta 0.01
¼Æʱ½á¹û
III. ³ÌÐòÔ±ÊÖ²á
36. Ìåϵ½á¹¹
Postgres Ìåϵ¸ÅÄî
37. À©Õ¹µÄ SQL: ¸ÅÊö
À©Õ¹ÐÔÊÇÈçºÎ¹¤×÷µÄ
Postgres ÀàÐÍϵͳ
¹ØÓÚ Postgres ϵͳ±í
38. À©Õ¹µÄ SQL: º¯Êý
²éѯÓïÑÔ£¨SQL£©º¯Êý
¹ý³ÌÓïÑÔº¯Êý
ÄÚ²¿º¯Êý
±àÒ루C£©ÓïÑÔº¯Êý
º¯ÊýÖØÔØ
39. À©Õ¹µÄ SQL: ÀàÐÍ
Óû§¶¨ÒåÀàÐÍ
40. À©Õ¹µÄ SQL: ²Ù×÷·û
²Ù×÷·ûÓÅ»¯ÐÅÏ¢
41. À©Õ¹µÄ SQL: ¾Û¼¯
42. Postgres ¹æÔòϵͳ
Querytree£¨²éѯÊ÷£©ÊÇʲô£¿
ÊÓͼºÍ¹æÔòϵͳ
INSERT£¬UPDATE ºÍ DELETE µÄ¹æÔò
¹æÔòºÍȨÏÞ
¹æÔòÓë´¥·¢Æ÷Ö®±È½Ï
43. À©Õ¹Ë÷Òý½Ó¿Ú
44. Ë÷Òý¿ªÏú¼ÆË㺯Êý
45. GiST Ë÷Òý
46. Á´½Ó¶¯Ì¬Á´½ÓµÄº¯Êý
Linux
DEC OSF/1
SunOS 4.xSolaris 2.x ºÍ HP-UX
47. ´¥·¢Æ÷
´´½¨´¥·¢Æ÷
Óë´¥·¢Æ÷¹ÜÀíÆ÷½»»¥
Êý¾Ý¸Ä±äµÄ¿ÉÊÓÐÔ
Àý×Ó
48. ·þÎñÆ÷±à³Ì½Ó¿Ú
½Ó¿Úº¯Êý
½Ó¿ÚÖ§³Öº¯Êý
´æ´¢Æ÷¹ÜÀí
Êý¾Ý¸Ä±äµÄ¿ÉÊÓÐÔ
Àý×Ó
49. ¹ý³ÌÓïÑÔ
°²×°¹ý³ÌÓïÑÔ
IV. ½Ó¿Ú
50. º¯Êý
51. ´ó¶ÔÏó
ÀúÊ·ÐÅÏ¢
ʵÏÖµÄÌصã
½Ó¿Ú
ÄÚ½¨µÄÒÑ×¢²áº¯Êý
ͨ¹ý LIBPQ ·ÃÎÊ´ó¶ÔÏó
Àý×Ó³ÌÐò
52. ecpg - ÔÚ C ÀïǶÈë SQL
ΪʲôҪǶÈë SQL£¿
¸ÅÄî
ÈçºÎʹÓàecpg
¾ÖÏÞ
´ÓÆäËû RDBMS Èí¼þ°üÒÆÖ²
°²×°
¼ÄÓ↑·¢Õß
53. libpq - C ¿â
Êý¾Ý¿âÁª½Óº¯Êý
²éѯִÐк¯Êý
Òì²½²éѯ´¦Àí
½Ý¾¶
Ò첽֪ͨ
Óë COPY ÃüÁîÏà¹ØÁªµÄº¯Êý
libpq ¸ú×Ùº¯Êý
libpq ¿ØÖƺ¯Êý
»·¾³±äÁ¿
Ïß³ÌÌØÐÔ
Àý×Ó³ÌÐò
54. libpq - C++ °ó¶¨¿â
¿ØÖƺͳõʼ»¯
libpq++ Àà
Êý¾Ý¿âÁª½Óº¯Êý
²éѯִÐк¯Êý
Ò첽֪ͨ
Óë COPY ÃüÁîÏà¹ØÁªµÄº¯Êý
55. pgtcl - TCL °ó¶¨¿â
ÃüÁî
Àý×Ó
pgtcl ÃüÁî²Î¿¼ÐÅÏ¢
56. libpgeasy - ¼ò»¯Á赀 C °ó¶¨¿â
57. ODBC ½Ó¿Ú
±³¾°
Windows Ó¦ÓÃ
Unix °²×°
ÅäÖÃÎļþ
ApplixWare
58. JDBC ½Ó¿Ú
ÖÆ×÷ JDBC ½Ó¿Ú
Ϊ JDBC×¼±¸Êý¾Ý¿â
ʹÓÃÇý¶¯
×°Èë JDBC
×°ÔØÇý¶¯
ÓëÊý¾Ý¿âÁª½Ó
·¢³ö²éѯºÍ´¦Àí½á¹û
Ö´ÐиüÐÂ
¹Ø±ÕÁª½Ó
ʹÓôó¶ÔÏó
Postgres ¶Ô JDBC APIµÄÀ©Õ¹
ÉîÈëÔĶÁ
59. Lisp ±à³Ì½Ó¿Ú
V. ¿ª·¢ÕßÊÖ²á
60. Postgres Ô´´úÂë
¸ñʽ
61. PostgreSQL ÄÚ²¿¸Åò
²éѯµÄ¹ý³Ì
Áª½ÓÊÇÈçºÎ½¨Á¢ÆðÀ´µÄ
·ÖÎöÆ÷½×¶Î
Postgres ¹æÔòϵͳ
¹æ»®Æ÷/ÓÅ»¯Æ÷
Ö´ÐÐÆ÷
62. pg_options
63. Êý¾Ý¿âϵͳÀïµÄ»ùÒò²éѯÓÅ»¯
×÷Ϊ¸´ÔÓÓÅ»¯ÎÊÌâµÄ²éѯ´¦Àí
»ùÒòËã·¨£¨GA£©
Postgres ÀïµÄ»ùÒò²éѯÓÅ»¯£¨GEQO£©
Postgres GEQO δÀ´µÄʵÏÖÈÎÎñ
64. Ç°¶Ë/ºó¶ËЭÒé
¸ÅÊö
ЭÒé
ÏûÏ¢Êý¾ÝÀàÐÍ
ÏûÏ¢¸ñʽ
65. Postgres ÐźÅ
66. gcc ȱʡÓÅ»¯
67. ºó¶Ë½Ó¿Ú
BKI Îļþ¸ñʽ
ͨÓÃÃüÁî
ºêÃüÁî
µ÷ÊÔÃüÁî
Àý×Ó
68. Ò³ÃæÎļþ
Ò³Ãæ½á¹¹
Îļþ
³ô³æ
VI. ½Ì³Ì
69. SQL
¹ØϵÊý¾ÝÄ£ÐÍ
¹ØϵÊý¾ÝÄ£Ð͹«Ê½
ÔÚ¹ØϵÊý¾ÝÄ£ÐÍÉϵIJÙ×÷
SQL ÓïÑÔ
70. Ìåϵ½á¹¹
Postgres Ìåϵ¸ÅÄî
71. ¿ªÊ¼
ÉèÖÃÄãµÄÔËÐл·¾³
ÔËÐÐSQL½çÃæ (psql)
¹ÜÀíÊý¾Ý¿â
72. ²éѯÓïÑÔ
SQL ½çÃæ
¸ÅÄî
´´½¨Ð±í
Ïò±íÖмÓÈë¼Ç¼
²éѯһ¸ö±í
ÖØж¨Ïò SELECT ²éѯ
Áª½Ó±í
¸üÐÂ
ɾ³ý
ʹÓþۼ¯º¯Êý
73. Postgres SQL ¸ß¼¶ÌØÐÔ
¼Ì³Ð
·ÇÔ­×ÓÊýÖµ
¸ü¶à¸ß¼¶ÌØÐÔ
VII. ¸½Â¼
UG1. ÈÕÆÚ/ʱ¼äÖ§³Ö
ʱÇø
ÀúÊ·
DG1. CVS ²Ö¿â
CVS Ê÷µÄ×éÖ¯
ͨ¹ýÄäÃû CVS»ñÈ¡Ô´´úÂë
ͨ¹ýCVSup»ñÈ¡Ô´´úÂë
DG2. Îĵµ
ÎĵµµØͼ
ÎĵµÏîÄ¿¼Æ»®
ÎĵµÔ´Îļþ
ÖÆ×÷Îĵµ
ÊÖ²áÒ³
v7.0ÎĵµÓ²¿½±´Éú³É
¹¤¾ß¼¯
¿ÉÑ¡¹¤¾ß¼¯
²Î¿¼ÊéÄ¿
±íĿ¼
3-1. Postgres Êý¾ÝÀàÐÍ
3-2. Postgres º¯Êý³£Á¿
3-3. Postgres Êý×ÖÀàÐÍ
3-4. Postgres »õ±ÒÀàÐÍ
3-5. Postgres ×Ö·ûÀàÐÍ
3-6. Postgres ÌØÊâ×Ö·ûÀàÐÍ
3-7. Postgres ÈÕÆÚ/ʱ¼äÀàÐÍ
3-8. Postgres ÈÕÆÚÊäÈë
3-9. Postgres Ô·ÝËõд
3-10. Postgres ÐÇÆÚËõд
3-11. Postgres ʱ¼äÊäÈë
3-12. Postgres ´øʱÇøʱ¼äÊäÈë
3-13. Postgres ʱÇøÊäÈë
3-14. Postgres ÌØÊâÈÕÆÚ/ʱ¼ä³£Á¿
3-15. Postgres ÈÕÆÚ/ʱ¼äÊä³ö·ç¸ñ
3-16. Postgres ÈÕÆÚ˳Ðò´«Í³
3-17. Postgres ²¼¶ûÀàÐÍ
3-18. Postgres ¼¸ºÎÀàÐÍ
3-19. PostgresIP °æ±¾ 4 ÀàÐÍ
3-20. PostgresIP ÀàÐÍÀý×Ó
4-1. ²Ù×÷·û˳Ðò£¨ÓÅÏȼ¶Ï½µ£©
4-2. Postgres ²Ù×÷·û
4-3. Postgres Êý×Ö²Ù×÷·û
4-4. Postgres ¼¸ºÎ²Ù×÷·û
4-5. Postgres ʱ¼ä¼ä¸ô²Ù×÷·û
4-6. PostgresIP V4 CIDR ²Ù×÷·û
4-7. PostgresIP V4 INET ²Ù×÷·û
5-1. SQL º¯Êý
5-2. Êýѧº¯Êý
5-3. ³¬Ô½Êýѧº¯Êý
5-4. SQL92 ×Ö·û´®º¯Êý
5-5. ×Ö·û´®º¯Êý
5-6. ÈÕÆÚ/ʱ¼äº¯Êý
5-7. ¸ñʽ»¯º¯Êý
5-8. ÓÃÓÚÈÕÆÚ/ʱ¼äת»»µÄÄ£°å
5-9. ÓÃÓÚÈÕÆÚ/ʱ¼äÄ£°å  to_char() µÄºó׺
5-10. ÓÃÓÚ to_char(numeric)µÄ Ä£°å
5-11. to_char Àý×Ó
5-12. ¼¸ºÎº¯Êý
5-13. ¼¸ºÎÀàÐÍת»»º¯Êý
5-14. ¼¸ºÎÉý¼¶º¯Êý
5-15. PostgresIP V4 º¯Êý
13-1. Postgres ¸ôÀ뼶±ð
19-1. Ò»¸ö¶þ½øÖÆ¿½±´ÎļþµÄÄÚÈÝ
22-1. Ö§³ÖµÄƽ̨
22-2. ²»Ö§³ÖµÄƽ̨
22-3. ²»¼æÈݵÄƽ̨
23-1. Kerberos ²ÎÊýÀý×Ó
34-1. Ŀ¼²¼¾Ö
37-1. Postgres ϵͳ±í
38-1. ÓÃÓÚÄÚ½¨ Postgres ÀàÐ͵ĵÈЧ C ÀàÐÍ
43-1. Ë÷Òý¹¹ÐÍ
43-2. B-tree ²ßÂÔ
55-1. pgtcl ÃüÁî
65-1. Postgres ÐźÅ
68-1. Àý×ÓÒ³Ãæ²¼¾Ö
UG1-1. Postgres ʶ±ðµÄʱÇø
UG1-2. Postgres °Ä´óÀûÑÇʱÇø
DG2-1. Postgres Îĵµ²úÆ·
DG2-2. Ŀ¼µÈЧ¸ñʽ
ͼƬÁбí
24-1. Postgres Îļþ²¼¾Ö
36-1. Áª½ÓÊÇÈçºÎ½¨Á¢ÆðÀ´µÄ
37-1. Ö÷ÒªµÄ Postgres ϵͳ±í
70-1. Áª½ÓÊÇÈçºÎ½¨Á¢ÆðÀ´µÄ
Àý×ÓÁбí
19-1. Ò»¸öÑ­»·ÖØд¹æÔòµÄÀý×Ó
27-1. pg_options Îļþ
61-1. Ò»¸ö¼òµ¥²éѯ
69-1. ¹©Ó¦É̺Ͳ¿¼þÊý¾Ý¿â
69-2. Ò»¸öÄÚ²¿Áª½Ó
69-3. Ò»¸öʹÓùØϵ´úÊýµÄ²éѯ
69-4. ´øÌõ¼þµÄ¼òµ¥²éѯ
69-5. ¾Û¼¯
69-6. ¾Û¼¯
69-7. Having
69-8. ×Ó²éѯ
69-9. Union, Intersect, Except
69-10. ´´½¨±í
69-11. ´´½¨Ë÷Òý

¡¡ ¡¡ ÏÂÒ»Ò³
¡¡ ¡¡ ÕªÒª
± ± ´