PostgreSQL

xiaoxiao2021-03-06  79

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

转载请注明原文地址:https://www.9cbs.com/read-121528.html

New Post(0)