PostgreSQL
The PostgreSQL Development Team
Edited by
Thomas Lockhart
PostgreSQLIS COPYRIGHT? 1996-2000 by PostgreSQL Inc. Compilation: He Weiping? Laser@zhengmai.com.cn Chinese translation Copyright Notice: The copyright of this article belongs to its Chinese translation. You can use the free communication of non-commercial use in this manual, but it will ensure the integrity of the manual, please keep this copyright statement when reprint. Due to the limited level of translator, the error is inevitable, I hope that users will correct. It is not responsible for all consequences of this.
content
Summary
I.
User Manual
1.
Introduction
What is? Postgres?
Simple review? Postgres
About this version
Resource
the term
symbol
Question report guidance
Y2K declaration
Copyright and trademark
2.
SQL syntax
Keyword
Comment
name
constant
Domain and column (field)
Operator
expression
3.
type of data
Numeric type
Currency type
Character type
Date / time type
Boolean type
Geometric type
IP version 4 network and host address
4.
Operator
Grammatical priority
General operator
Digital operator
Geometric operator
Time interval operator
IP V4 CIDR operator
IP v4 inet operator
5.
function
SQL function
Mathematical function
String function
Date / time function
Format function
Geometric function
IP V4 function
6.
Type conversion
Overview
Operator
function
Inquiry target
Union query
7.
Index and keyword
Keyword
Partial index
8.
Array
9.
inherit
10.
PL / PGSQL - SQL Process Language
Overview
description
example
11.
PL / TCL - TCL Process Language
Overview
description
12.
PL / Perl - Perl Process Language
Overview
Production and installation
Use PL / Perl
13.
Multi-version parallel control
Introduction
Transaction isolation
Read has been submitted
Serialized isolation level
Lock and table
Lock and index
Application layer data integrity check
14.
Set up a running environment
15.
Management database
Create a database
Transform database location
Access database
Delete database
16.
Disk storage
17.
Comprehension performance
Use explain
18.
Add a record to the database
Turn off automatic submission
Use a COPY from
Delete index
19.
SQL command
Abort - Exit the current transaction
Alter Group - Add new users to the group, remove users from the group
ALTER TABLE - Modify Table Properties
ALTER USER - Modify User Account Information
Begin - starting a transaction in chain mode
Close - close a cursor
Cluster - Suggestions for Server Storage Clusters
Comment - Increase comment to an object
Commit - Submit the current transaction
Copy - copy data between files and tables
Create AggRegate - Define a new gathering function
Create ConsTRAINT TRIGGER - Create a trigger that supports constraints
CREATE DATABASE - Create a new database
CREATE FUNCTION - Define a new function
Create Group - Create a new group
Create Index - Constructing a from the index
Create Language - Define a new language for functions
Create Operator - Define a new user operator
CREATE RULE - Define a new rule
Create Sequence - Create a new sequence number generator
CREATE TABLE - Create a new table
Create Table As - Create a new table
CREATE TRIGGER - Create a new trigger
CREATE TYPE - Define a new basic data type
Create User - Create a new database user Create View - Constructing a virtual table
Declare - Define a cursor for accessing the database
Delete - Remove the row from the table
DROP AGGREGATE - Delete a definition of a gathering function
DROP DATABASE - Delete an existing table
DROP FUNCTION - Delete a user-defined C function
Drop Group - Delete a group
Drop Index - Delete an index from a database
DROP LANGUAGE - Delete a user-defined process language
DROP OPERATOR - Remove an operator from the database
DROP RULE - Delete an existing rule from the database
DROP SEQUENCE - Delete an existing sequence
DROP TABLE - Remove the existing table from a database
DROP TRIGGER -? Delete a trigger definition
DROP TYPE - Delete a user-defined type from the system table
Drop User - Delete a user
DROP View - Delete an existing view from the database
END - Submit the current transaction
Explain - Display Statement Execution Plan
FETCH - get the line with a cursor
Grant - gives permissions for a user, a group or all users
INSERT - Insert a new line to the database
Listen - Listening to a notification condition
Load - Dynamically load an object file
Lock - Explicitly locked a table in one transaction
Move - Mobile Cursor
Notify - Notify all backends and front ends listening to a certain notification condition
Reindex - Recover the destroyed system index under single-process single user postgres criteria
RESET - Restore default runtime parameters for sessions
Revoke - Abolition of a user, a group or all user access
Rollback - Exit the current transaction
SELECT - Retrieve line from a table or view
Select Into - Create a new table from an existing table or view
SET - Set the runtime parameters for the session
Show - Show runtime parameters for sessions
Truncate - Clear a table
Unlisten - Saard of the stop notification conditions
Update - Convert a value of a field in a table
Vacuum - Clean up and analyze one?
Postgres database
20.
application
CREATEDB - Create a new one?
Postgres database
Createlang - one?
Postgres database adds a new programming language
CreateUser - Create a new one?
Postgres users
DropDB - Delete an existing?
Postgres database
Droplang - from one?
Postgres database deletes a programming language
DROPUSER - Delete one?
Postgres users
ECPG - Embedded SQL C Preface
PGACCESS -
Postgres graphic interactive client
Pgadmin -?
Postgres for? Database management and design tools for Windows 95/98 / NT® platform
PG_CTL - Start, stop and restart Postmaster
PG_DUMP - put one?
Postgres database extracted into a script file
PG_DUMPALL - put all?
Postgres database extracted into a script file
PSQL -?
POSTGRES interaction terminal
PGTCLSH -?
Postgres TCL Shell Client
PGTKSH -?
Postgres graphic TCL / TK shell
Vacuumdb - Clean up and analyze one?
Postgres database
twenty one.
system applications
INitdb -? Create a new one?
Postgres database installation
INITLOCATION - Create a subordinate?
Postgres Database Savings
ipcclean - Set shared memory and signal lights for exiting backend
PG_PASSWD - Management Flat Password Document
PG_UPGRADE - Allows not reloading data from the previous version upgrade Postgres - run one?
Postgres single user backend
Postmaster - operation?
POSTGRES multi-user backend
II.
Administrator manual
twenty two.
transplant
Currently supported platform
Not supported platform
twenty three.
Configuration option
Configure parameters
Production parameters (Make)
Localization support
Kerberos certification
twenty four.
System layout
25.
installation
Before installation
Installation process
26.
Install on Win32
Fabrication library
Installation library
Library
27.
Runtime environment
Use in UNIX? Postgres
Start? Postmaster
Use pg_options
28.
safety
User Authentication
User name and group
Access control
Functions and rules
Safety TCP / IP connection
29.
Add and delete users
30.
Disk management
Change (storage) location
31.
Management database
Create a database
Access database
Delete database
Backup and recovery
32.
Transformation test
Postmaster starts failed
Client connection problem
Debugging information
33.
Database recovery
34.
Transformation test
Transform test environment
Transformation test process
Transformation analysis
Platform-related comparison file
35.
Version Information
Version 7.0
Version 6.5.3
Version 6.5.2
Version 6.5.1
Version 6.5
Version 6.4.2
Version 6.4.1
Version 6.4
Version 6.3.2
Version 6.3.1
Version 6.3
Version 6.2.1
Version 6.2
Version 6.1.1
Version 6.1
Version V6.0
Version v1.09
Version v1.02
Version V1.01
Version V1.0
Postgres95
Beta 0.03
Postgres95
Beta 0.02
Postgres95
Beta 0.01
Time results
III.
Programmer manual
36.
Architecture
Postgres
System concept
37.
Extended? SQL: Overview
How is extended?
Postgres
Type system
About? Postgres system table
38.
Extended? SQL: Function
Query language (SQL) function
Process language function
Internal function
Compile (C) language function
Function overload
39.
Extended? SQL: Type
User definition type
40.
Extended? SQL: operator
Operator optimization information
41.
Extended? SQL: gather
42.?
Postgres
Rule system
What is QueryTree?
View and rule system
INSERT, UPDATE and DELETE rules
Rules and permissions
Comparison between rules and triggers
43.
Extended index interface
44.
Index overhead calculation function
45.
Gist index
46.
Link Dynamic Link Function
Linux
DEC OSF / 1
Sunos 4.x
,? Solaris 2.x and? HP-UX
47.
trigger
Create trigger
Interact with trigger manager
Data change visibility
example
48.
Server programming interface
Interface function
Interface support function
Memory management
Data change visibility
example
49.
Process language
Installation Process Language
IV.
interface
50.
function
51.
Big object
history information
Implementation
interface
Built-in registration function
Accessing large objects via LibPQ
Example program
52.?
ECPG
- Is it embedd in? SQL? SQL
Why is it embedded? Sql?
concept
How to use? ECPG
Limit
From other? RDBMS software package transplantation
installation
Message developer
53.
Libpq - C library
Database coupling function
Query execution function
Asynchronous query processing
shortcut
Asynchronous notice
Functions associated with the copy command
Libpq
Track function
Libpq
Control function
Environment variable
Thread characteristics
Example program
54.
Libpq - C binding library
Control and initialization
Libpq class
Database coupling function
Query execution function
Asynchronous notice
Functions associated with the copy command
55.
PGTCL - TCL Binding Library
command
example
PGTCL Command Reference Information
56.
LibpGeasy - Simplified C Binding Library
57.
ODBC interface
background
Windows
application
UNIX installation
Profile
Applixware
58.
JDBC interface
What? JDBC interface
Prepare the database? JDBC
Use drive
Load? JDBC
Load drive
Union with database
Send query and processing results
Execute update
Shut down join
Use big object
Postgres
The extension of the JDBC? API
In-depth reading
59.
Lisp programming interface
V.
Developer manual
60.
Postgres source code
format
61.
PostgreSQL internal profile
Query process
How to establish
Analyzer stage
Postgres
Rule system
Planner / optimizer
Actuator
62.
PG_OPTIONS
63.
Genetic query optimization in the database system
Inquiry processing as a complex optimization problem
Gene Algorithm (GA)
Genetic query optimization in Postgres (GEQO)
Postgres
GEQO future realization tasks
64.
Front / backend protocol
Overview
protocol
Message data type
Message format
65.?
Postgres
signal
66.?
GCC
Default optimization
67.
Rear end interface
BKI
file format
General command
Macro command
Debug command
example
68.
Page file
Page structure
file
bed bugs
VI.
Tutorial
69.
SQL
Relationship data model
Relationship data model formula
Operation on the relational data model
SQL
Language
70.
Architecture
Postgres
System concept
71.
Start
Set your operating environment
Run SQL interface (PSQL)
Management database
72.
Query language
SQL interface
concept
Create a new table
Add records to the table
Query a table
Replay SELECT query
Join table
Update
delete
Use aggregation functions
73.?
Postgres
? SQL advanced features
inherit
Non-atomic value
More advanced features
VII.
appendix
UG1.
Date / Time Support
Time zone
history
DG1.?
Cvs
warehouse
Cvs
Tree organization
Get the source code by anonymous? CVS
Get source code via CVSUP
DG2.
Documentation
Document map
Document project plan
Document source file
Making documentation
Handbook
V7.0 document hard copy generation
Toolset
Optional tool set
bibliography
Table catalog
3-1.?
Postgres
type of data
3-2.?
Postgres
Function constant
3-3.?
Postgres
Digital type
3-4.?
Postgres
Currency type
3-5.?
Postgres
Character type
3-6.?
Postgres
Special character type
3-7.?
Postgres
Date / time type
3-8.?
Postgres
Date input
3-9.?
Postgres
Month abbreviation
3-10.?
Postgres
Week
3-11.?
Postgres
Time input
3-12.?
Postgres
Time area input
3-13.?
Postgres
Time zone input
3-14.?
Postgres
Special date / time constant
3-15.?
Postgres
Date / time output style
3-16.?
Postgres
Date sequence
3-17.?
Postgres
Boolean type
3-18.?
Postgres
Geometric type
3-19.?
Postgres
IP version 4 type
3-20.?
Postgres
IP type example
4-1.
Operation order (priority drop)
4-2.?
Postgres
Operator
4-3.?
Postgres
Digital operator
4-4.?
Postgres
Geometric operator
4-5.?
Postgres
Time interval operator
4-6.?
Postgres
IP V4 CIDR operator
4-7.?
Postgres
IP v4 inet operator
5-1.
SQL function
5-2.
Mathematical function
5-3.
Beyond mathematical functions
5-4.?
SQL92
String function
5-5.
String function
5-6.
Date / time function
5-7.
Format function
5-8.
Template for date / time conversion
5-9.
Date / time template? TO_CHAR () suffix
5-10.
Template for TO_CHAR (Numeric)
5-11.
TO_CHAR example
5-12.
Geometric function
5-13.
Geometric type conversion function
5-14.
Geometric upgrade function
5-15.?
Postgres
IP V4 function
13-1.?
Postgres
Isolation level
19-1.
Content of a binary copy file
22-1.
Supported platform
22-2.
Not supported platform
22-3.
Incompatible platform
23-1.
Kerberos parameter example
34-1.
Directory layout
37-1.
Postgres system table
38-1.
Equivalent C type for built-in? Postgres type
43-1.
Index configuration
43-2.
B-Tree Policy
55-1.
PGTCL command
65-1.?
Postgres
signal
68-1.
Example page layout
UG1-1.?
Postgres
Time zone identified
UG1-2.?
Postgres
Australian Time Zone
DG2-1.?
Postgres
Document product
DG2-2.
Directory equivalent format
Picture list
24-1.?
Postgres
File layout
36-1.
How to establish
37-1.
Main? Postgres system table
70-1.
How to establish
Example list
19-1.
Example of a loop rewriting rule
27-1.
PG_OPTIONS file
61-1.
A simple query
69-1.
Suppliers and components database
69-2.
An internal join
69-3.
A query using the relationship algebra
69-4.
Simple query with conditions
69-5.
Gather
69-6.
Gather
69-7.
Having
69-8.
Subquerice
69-9.
Union, INTERSECT, EXCEPT
69-10.
Create a table
69-11.
Create an index