PostgreSQL

Covering v6.3 for general release

by The PostgreSQL Development Team

Edited by Thomas Lockhart

(last updated 1998-02-23)

PostgreSQL is copyright (C) 1998 by the Postgres Global Development Group.

Table of Contents
����
I. ���塼�ȥꥢ��
1. ����ȥ����������
Postgres �Ȥϲ��Ǥ���?
Postgres����
���Υ�꡼���ˤĤ���
�꥽����
����Ⱦ�ɸ
2. �������ƥ�����
Postgres�������ƥ�����γ�ǰ
3. ��������
��������
����Ū��˥�(psql)�Υ�������
�ǡ����١����δ���
4. �䤤��碌����
����Ū��˥�
����
�������饹�κ���
���󥹥��󥹤Υ��饹�ؤ�����
���饹���䤤��碌
SELECT �䤤��碌�θ���ľ��
���饹�η��
����
���
����ؿ��λ���
5. Advanced Postgres SQL Features
Inheritance
Non-Atomic Values
Time Travel
More Advanced Features
II. �桼������������
6. ��������
7. �ǡ����١����δ���
�ǡ����١����κ���
�̤Υǡ����١����ξ��
�ǡ����١����ؤΥ�������
�ǡ����١����κ��
8. �ǡ�����
���ͷ�
��۷�
ʸ����
���ա����﷿
�֡��뷿
��ɸ��
9. �黻��
10. �ؿ�
11. Arrays
12. �Ѿ�
13. �䤤��碌����
����
�������饹�κ���
���󥹥��󥹤Υ��饹�ؤ�����
���饹���䤤��碌
SELECT �䤤��碌�θ���ľ��
���饹�η��
����
���
����ؿ��λ���
14. Disk Storage
15. psql
Paging To Screen
16. pgaccess
III. �����ԥ�����
17. �ݡ��ƥ���
����ư��Ƥ���ץ�åȥۡ���
ư��ʤ��ץ�åȥۡ���
18. Installation
Requirements to Run Postgres
Installation Procedure
Playing with Postgres
The Next Step
Porting Notes
19. Runtime Environment
Locale Support
20. Starting postmaster
21. Adding and Deleting Users
22. Disk Management
Alternate Locations
23. Troubleshooting
24. Managing a Database
Creating a Database
Accessing a Database
Destroying a Database
25. Database Recovery
26. Regression �ƥ���
Regression ��
�ǥ��쥯�ȥ깽��
Regression �ƥ��Ȥ�ή��
Regression ��̤β���
27. ��꡼���Ρ���
��꡼�� 6.3
��꡼�� 6.2.1
Release 6.2
��꡼�� 6.1
�����ߥ󥰤ˤ����(Timing Results)
IV. �ץ�����ޡ���������
28. ����ȥ����������
����Ⱦ�ɸ
29. �������ƥ�����
Postgres�������ƥ�����γ�ǰ
30. Extending SQL: An Overview
How Extensibility Works
The Postgres Type System
About the Postgres System Catalogs
31. Extending SQL: Functions
Query Language (SQL) Functions
Programming Language Functions
32. ��ĥ SQL����
�桼�������
33. ��ĥ SQL���黻��
34. Extending SQL: Aggregates
35. Postgres�롼�륷���ƥ�
36. ����ǥå�����ĥ��ǽ�ؤΥ��󥿡��ե�����
37. GiST Indices
38. ưŪ�����ɴؿ��Υ��
ULTRIX
DEC OSF/1
SunOS 4.x, Solaris 2.x and HP-UX
39. Triggers
Trigger Creation
Interaction with the Trigger Manager
Visibility of Data Changes
Examples
40. Server Programming Interface
���󥿡��ե������ؿ�
���󥿡��ե���������ؿ�
Memory Management�������
Visibility of Data Changes �ǡ����ѹ��βĻ���
Examples��
41. libpq
Control and Initialization
Database Connection Functions
Query Execution Functions
Fast Path
Asynchronous Notification
Functions Associated with the COPY Command
libpq Tracing Functions
User Authentication Functions
BUGS
Sample Programs
V. ��ե����
42. Functions
43. �顼��(�����)���֥�������(Large Objects)
��������
ž�֥顼�����֥�������
�顼�����֥������ȡ����󥿡��ե�����
�Ȥ߹�����Ͽ���줿�ؿ�
LIBPQ ����Υ顼�����֥������ȤΥ�������
����ץ롦�ץ������
44. ecpg - Embedded SQL in C
Why Embedded SQL?
The Concept
How To Use egpc
Limitations
Porting From Other RDBMS Packages
Installation
For the Developer
45. libpq
Control and Initialization
Database Connection Functions
Query Execution Functions
Fast Path
Asynchronous Notification
Functions Associated with the COPY Command
libpq Tracing Functions
User Authentication Functions
BUGS
Sample Programs
46. pgtcl
Commands
Examples
Reference Information
47. ODBC ���󥿡��ե�����
�ط�
48. JDBC Interface
VI. ��ȯ�ԥ�����
49. �������ƥ�����
Postgres�������ƥ�����γ�ǰ
50. �ǡ����١��������ƥ�ˤ����롤����Ū�䤤��碌�κ�Ŭ��
ʣ���ʺ�Ŭ������Ȥ��Ƥ��䤤��碌��������
����Ū���르�ꥺ��(Genetic Algorithms(GA))
Postgres �ˤ����롤����Ū�䤤��碌�κ�Ŭ�� (GEQO)
PostgresGEQO�˴ؤ��� ����μ�����ȡ�
51. �ե���ȥ����/�Хå������ �ץ��ȥ���
����
�ץ��ȥ���
��å������ǡ�����
��������
52. GCC �Υǥե�����ͤκ�Ŭ��
VII. ��Ͽ
A. Documentation
�Ϥ����
��������Ƚ���
ʸ��ι���
�ġ��륻�å�
v6.3 �ˤ��������ʪ������
����¾�Υġ��륻�å�
B. Contacts
�Ϥ����
�ط���
SQL References
Index

  Next
  ����