PostgreSQL
The PostgreSQL Development Team
Edited by
Thomas Lockhart
PostgreSQL
is 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 ͼÐλ¯½»»¥¿Í»§¶Ë
 
- 
pgadmin
- Postgres ÓÃÓÚ  Windows
95/98/NT  ƽ̨µÄÊý¾Ý¿â¹ÜÀíºÍÉè¼Æ¹¤¾ß
 
- 
pg_ctl - Æô¶¯£¬Í£Ö¹¡¡ºÍÖØÐÂÆô¶¯
postmaster
 
- 
pg_dump -
°ÑÒ»¸ö Postgres Êý¾Ý¿â³é³öµ½Ò»¸ö½Å±¾ÎļþÀï
 
- 
pg_dumpall
- °ÑËùÓРPostgres Êý¾Ý¿â³é³öµ½Ò»¸ö½Å±¾ÎļþÀï
 
- 
psql - Postgres
½»»¥µÄÖÕ¶Ë
 
- 
pgtclsh
- Postgres TCL shell ¿Í»§¶Ë
 
- 
pgtksh - Postgres
ͼÐλ¯µÄ 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.x, Solaris
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. ´´½¨Ë÷Òý
 
± ± ´