¾�ΥС��ʸ�� 17 | 16 | 15 | 14 | 13 | 12 | 11 | 10 | 9.6 | 9.5 | 9.4 | 9.3 | 9.2 | 9.1 | 9.0 | 8.4 | 8.3 | 8.2 | 8.1 | 8.0 | 7.4 | 7.3 | 7.2

PostgreSQL 7.3.4 �ץ��ޥ��

PostgreSQL ��Х볫ȯ��롼��

Copyright © 1996-2002 by PostgreSQL ��Х볫ȯ��롼��

Table of Contents

�Ϥ��

1. PostgreSQL�Ȥ�?

2. PostgreSQL ��

2.1. �С��쥤�� POSTGRES �ץ��
2.2. Postgres95
2.3. PostgreSQL

3. �ܽ�ι��

4. �ɥ��ȥ꥽��γ��

5. �Ѹ��ɽ��

6. �Х��ݡ��ȥ��ɥ饤��

6.1. �Х��
6.2. ��𤹤٤��
6.3. �Х��

I. ��饤��ȥ��󥿥ե��

1. libpq - C �饤�֥��

1.1. ��ʸ
1.2. �ǡ��١��³�ؿ�
1.3. �䤤��碌�¹Դؿ�
1.4. ��Ʊ��䤤��碌�ؿ�
1.5. ��ƻ��󥿥ե��
1.6. ��Ʊ��
1.7. COPY ��ޥ�ɤ˴�Ϣ��ؿ�
1.8. libpq �ȥ졼��ؿ�
1.9. libpq ��ؿ�
1.10. �Ķ��ѿ�
1.11. �ե��
1.12. ��åɤο��
1.13. Libpq �ץ��ι��
1.14. ��ץ�ץ��

2. �顼��֥��

2.1. ��ʸ
2.2. ��ǽ
2.3. ��󥿥ե��
2.4. ��¦��Ȥ߹��ߴؿ�
2.5. Libpq��顼��֥��ȤؤΥ��

3. pgtcl - Tcl ��饤�֥��

3.1. ��ʸ
3.2. ��ץꥱ��ؤ� pgtcl �Υ��
3.3. pgtcl ��ޥ�ɥ�ե��󥹾��

4. ECPG��C��Ǥ��SQL

4.1. ��ǰ
4.2. �ǡ��١��Фؤ��³
4.3. ��³��Ĥ��
4.4. SQL ��ޥ�ɤμ¹�
4.5. �ǡ��Ϥ�
4.6. ��顼��
4.7. �ե��Υ��󥯥롼��
4.8. �� SQL �ץ��ν��
4.9. �饤�֥��ؿ�
4.10. ¾��RDBMS�ѥå��ΰܿ�
4.11. ��ȯ�Ը��

5. JDBC ��󥿥ե��

5.1. JDBC �ɥ饤�ФΥ��åȥ��å�
5.2. �ɥ饤�Фλ��
5.3. �䤤��碌��ȯ�Ԥȷ�̤ν��
5.4. ��μ¹�
5.5. �ǡ��١��֥��Ȥκ��ѹ�
5.6. �Х��ʥ�ǡ��γ�Ǽ
5.7. PostgreSQL �� JDBC API �ؤγ�ĥ
5.8. �ޥ��åɤ��뤤�ϥ��֥�åȴĶ��ˤ��ɥ饤�Фλ��
5.9. ��³�ס��ȥǡ��
5.10. ��ɤ�٤��

6. PyGreSQL - Python ��󥿥ե��

6.1. pg �⥸�塼��
6.2. pg �⥸�塼��ؿ�
6.3. ��³��֥��:pgobject
6.4. �ǡ��١��åѥ��饹:DB
6.5. �䤤��碌��̥��֥��:pgqueryobject
6.6. �顼��֥��:pglarge

II. ��Хץ��ߥ�

7. ��߷׹�¤

7.1. PostgreSQL �δ��߷׹�¤�γ�ǰ

8. SQL �γ�ĥ��ά

8.1. ��ĥ�κ��ˡ
8.2. PostgreSQL�η��ƥ�
8.3. PostgreSQL��ƥ५��ˤĤ��

9. SQL �γ�ĥ:�ؿ�

9.1. ��ʸ
9.2. �䤤��碌�� (SQL) �ؿ�
9.3. ��³��ؿ�
9.4. ��ؿ�
9.5. C ��ؿ�
9.6. �ؿ��Υ��Х饤��
9.7. �ơ��֥�ؿ�
9.8. ��³��ϥ�ɥ�

10. SQL �γ�ĥ:�ǡ��

11. SQL�γ�ĥ:�黻��

11.1. ��ʸ
11.2. ��
11.3. �黻�Һ�Ŭ��˴ؤ��

12. SQL�γ�ĥ��

13. �롼�륷��ƥ�

13.1. ��ʸ
13.2. �䤤��碌�ĥ꡼�Ȥ�
13.3. �ӥ塼�ȥ롼�륷��ƥ�
13.4. INSERT��UPDATE��DELETE�ˤĤ��ƤΥ롼��
13.5. �롼��ȸ��
13.6. �롼�뤪��ӥ��ޥ�ɤξ��
13.7. �롼��Хȥꥬ

14. ��ǥå��ĥ��ǽ�ؤΥ��󥿥ե��

14.1. ��ʸ
14.2. ��᥽�åɤ��ӱ黻�ҥ��饹
14.3. ��᥽�åɤΥ��ȥ�ƥ�
14.4. ��᥽�åɤΥ��ݡ��ȥ롼��
14.5. �黻�Ҥȥ��ݡ��ȥ롼��κ��
14.6. �黻�ҥ��饹�κ��
14.7. �黻�ҥ��饹��ü�ʵ�ǽ

15. ��ǥå��ȳ��ؿ�

16. �ȥꥬ

16.1. �ȥꥬ��
16.2. �ȥꥬ�ޥ͡��Ȥδط�
16.3. �ǡ��ѹ��βĻ��
16.4. ��

17. ��С��ץ��೫ȯ�ѥ��󥿡��ե��

17.1. ��󥿡��ե��ؿ�
17.2. ��󥿥ե��ݡ��ȴؿ�
17.3. ��
17.4. �ǡ��ѹ��βĻ��
17.5. ��

III. ��³��

18. ��³��

18.1. ��ʸ
18.2. ��³��Υ��󥹥ȡ��

19. PL/pgSQL - SQL ��³��

19.1. ��
19.2. PL/pgSQL �ι�¤
19.3. ��
19.4. ��
19.5. ��Ū��ʸ
19.6. ��湽¤
19.7. ��
19.8. ��顼�ȥ�å��
19.9. �ȥꥬ�ץ��
19.10. ��
19.11. Oracle PL/SQL ��ΰܿ�

20. PL/Tcl - Tcl ��³��

20.1. ��
20.2. ��

21. PL/Perl - Perl ��³��

21.1. PL/Perl �ؿ��Ȱ��
21.2. PL/Perl �ˤ��ǡ��
21.3. PL/Perl��Υǡ��١��
21.4. ��ꤵ�줿 PL/Per ��ӿ��ꤵ��ʤ� PL/Perl
21.5. ¸�ߤ��ʤ��ǽ

22. PL/Python - Python ��³��

22.1. PL/Python �ؿ�
22.2. �ȥꥬ�ؿ�
22.3. �ǡ��١��
22.4. ��¤��줿�Ķ�

��ʸ��

List of Tables
3-1. pgtcl ��ޥ��
5-1. ConnectionPoolDataSource ��
5-2. ConnectionPoolDataSource ��ץ��ѥƥ�
5-3. DataSource ��
5-4. DataSource ��ץ��ѥƥ�
5-5. �ɲäΥס�� DataSource ��ץ��ѥƥ�
8-1. PostgreSQL��ƥ५��
9-1. PostgreSQL ��Ȥ߹��߷��Ʊ�� C ��췿
14-1. B-tree ��ȥ�ƥ�
14-2. �ϥå��她�ȥ�ƥ�
14-3. R-tree ��ȥ�ƥ�
14-4. B-tree ��ݡ��ȴؿ�
14-5. �ϥå��奵�ݡ��ȴؿ�
14-6. R-tree ��ݡ��ȴؿ�
14-7. GiST ��ݡ��ȴؿ�
19-1. ��󥰥륯��ȤΥ��׿�

List of Figures
7-1. ��³��Ω��ˡ
8-1. ��פ�PostgreSQL��ƥ५��

List of Examples
1-1. libpq ��ץ�ץ�� 1
1-2. libpq ��ץ�ץ�� 2
1-3. libpq ��ץ�ץ�� 3
2-1. Libpq ��Ѥ��顼��֥��ȤΥץ��
3-1. pgtcl �ץ��
5-1. JDCB �Ǵ�ñ��䤤��碌��
5-2. ��ñ�ʺ��
5-3. �ơ��֥��
5-4. �Х��ʥ�ǡ��
5-5. ConnectionPoolDataSource ��
5-6. DataSource ��
5-7. DataSource JNDI ��
18-1. PL/pgSQL �μ��Ȥˤ�륤�󥹥ȡ��
19-1. PL/pgSQL �ȥꥬ�ץ��
19-2. ��ͤ򥤥󥯥��Ȥ��ñ�� PL/pgSQL �ؿ�
19-3. ʸ��Ϣ��δ�ñ�� PL/pgSQL �ؿ�
19-4. ʣ�緿��Ȥä� PL/pgSQL �ؿ�
19-5. ��ñ�ʴؿ�
19-6. ¾�δؿ��Ф��ؿ�
19-7. ��ʸ��ץ��ȡ�OUT �ѥ�᡼��

		Next
		�Ϥ��