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. ´´½¨Ë÷Òý
± ± ´