Документация по PostgreSQL 8.2devel
Prev	Fast Backward

Index

автоувеличение

see serial

база данных

создание, Создание базы данных

базовый тип, Система типов PostgreSQL

битовая строка

тип данных, Типы битовых строк

бокс (тип данных), Боксы

дата, Типы дата/времени, Даты

формат вывода, Вывод даты/времени

see also форматирование

константы, Специальные значения

дата и время, Типы дата/времени, Дата и время

дата и время без временной зоны, Типы дата/времени, Дата и время

дата и время с временной зоной, Типы дата/времени, Дата и время

доступ

see привилегия

двоичные данные, Двоичные типы данных

двойная точность, Типы с плавающей точкой

функция

полиморфическая, Полимофмический тип

идентификатор объекта

тип данных, Типы идентификаторов объектов

имя

неполное, Путь поиска схемы

полное, Создание схемы

интерфейсы, Отдельно разрабатываемые интерфейсы

интервал, Типы дата/времени

исключение ограничения целостности, Разделение и исключение ограничений целостности

истина, Логический тип

история

PostgreSQL, Краткая история PostgreSQL

колонка, Основы таблиц

добавление, Добавление колонки

переименование, Переименование колонки

системная колонка, Системные колонки

удаление, Удаление колонки

константы, Константы

круг, Круги

ложь, Логический тип

метка

see псевдоним

наследование, Наследование, Наследование

неполное имя, Путь поиска схемы

обновление, Обновление данных, Если вы производите обновление

объединение, Объдиненённые таблицы

natural, Объдиненённые таблицы

пересечение, Объдиненённые таблицы

внешнее, Объдиненённые таблицы

объединение пересечение, Объдиненённые таблицы

ограничение

check, Ограничения Check

NOT NULL, Ограничения не-Null

добавление, Добавление ограничения

имя, Ограничения Check

первичный ключ, Первичные ключи

удаление, Удаление ограничения

уникальность, Ограничения уникальности

внешний ключ, Внешние ключи

ограничение check, Ограничения Check

ограничение целостности, Ограничения целостности

ограничение не-null, Ограничения не-Null

ограничение уникальности, Ограничения уникальности

отрезок, Сегменты линий

параметр

синтаксис, Позиционные параметры

первичный ключ, Первичные ключи

плавающая точка, Типы с плавающей точкой

полигон, Полигоны

полимофмический тип, Полимофмический тип

полиморфическая функция, Полимофмический тип

полное имя, Создание схемы

последовательность

и серийный тип, Серийные типы

позапрос, Агрегатные функции

привилегия, Привилегии

для схем, Схемы и привилегии

псевдоним

для имени таблицы в запросе, Объединения таблиц (Join)

в предложении FROM, Псевдонимы таблиц и колонок

путь (тип данных), Пути

путь поиска, Путь поиска схемы

путь_поиска, Путь поиска схемы

расширения, Расширения

разделение, Разделение

рергессивные тесты, Процедура установки

сегмент линии, Сегменты линий

сеть

тип данных, Типы сетевых адресов

схема, Схемы

public, Схема public

создание, Создание схемы

текущая, Путь поиска схемы

удаление, Создание схемы

символ, Символьные типы

символьные строки

константа, Строковые константы

типы данных, Символьные типы

системный каталог

схема, Схема системного каталога

скалярное

see выражение

составной тип, Система типов PostgreSQL

ссылка на колонку, Ссылки на колонку

ссылочная целостность, Внешние ключи (Foreign Keys), Внешние ключи

строка, Основы таблиц

see символьная строка

таблица, Основы таблиц

изменение, Изменение таблиц

наследование, Наследование

переименование, Переименование таблицы

разделение, Разделение

создание, Основы таблиц

удаление, Основы таблиц

табличное выражение, Табличные выражения

текст, Символьные типы

тип

see тип данных
полиморфический, Полимофмический тип

тип данных, Типы данных

базовый, Система типов PostgreSQL

составной, Система типов PostgreSQL

числовой, Числовые типы

тип данных колонки

изменение, Изменение типа данных колонки

точка, Точки

транзакция, Транзакции

удаление, Удаление данных

установка, Инструкции по установке

на Windows, Требования, Установка клиента на Windows

внешнее объединение, Объдиненённые таблицы

внешний ключ, Внешние ключи (Foreign Keys), Внешние ключи

временная зона, Временные зоны

временной промежуток, Типы дата/времени

время, Типы дата/времени, Время

формат вывода, Вывод даты/времени

see also форматирование

константы, Специальные значения

время без временной зоны, Типы дата/времени, Время

время с временной зоной, Типы дата/времени, Время

выражение

синтаксис, Выражения, возвращающие одиночное значение

выражение, возвращающее одиночное значение, Выражения, возвращающие одиночное значение

заключение в знаках доллара, Константы, заключенные в знаках доллара

запрос, Запросы

значение null

с ограничениями check, Ограничения Check

с ограничениями уникальности, Ограничения уникальности

значение по умолчанию, Значения по умолчанию

изменение, Изменение значения по умолчанию для колонки

четырёхугольник, Боксы

Логический

тип данных, Логический тип

Представление, Представления (Views)

A

ABORT, ABORT

abs, Mathematical Functions and Operators

acos, Mathematical Functions and Operators

add_missing_from configuration parameter, Previous PostgreSQL Versions

age, Date/Time Functions and Operators

aggregate function, Агрегатные функции

built-in, Aggregate Functions

invocation, Aggregate Expressions

user-defined, User-Defined Aggregates

AIX

IPC configuration, Shared Memory and Semaphores

alias

in the FROM clause, Псевдонимы таблиц и колонок

in the select list, Column Labels

ALL, Subquery Expressions, Row and Array Comparisons

allow_system_table_mods configuration parameter, Developer Options

ALTER AGGREGATE, ALTER AGGREGATE

ALTER CONVERSION, ALTER CONVERSION

ALTER DATABASE, ALTER DATABASE

ALTER DOMAIN, ALTER DOMAIN

ALTER FUNCTION, ALTER FUNCTION

ALTER GROUP, ALTER GROUP

ALTER INDEX, ALTER INDEX

ALTER LANGUAGE, ALTER LANGUAGE

ALTER OPERATOR, ALTER OPERATOR

ALTER OPERATOR CLASS, ALTER OPERATOR CLASS

ALTER ROLE, Role Attributes, ALTER ROLE

ALTER SCHEMA, ALTER SCHEMA

ALTER SEQUENCE, ALTER SEQUENCE

ALTER TABLE, ALTER TABLE

ALTER TABLESPACE, ALTER TABLESPACE

ALTER TRIGGER, ALTER TRIGGER

ALTER TYPE, ALTER TYPE

ALTER USER, ALTER USER

ANALYZE, Updating planner statistics, ANALYZE

AND (operator), Logical Operators

any, Псевдо-типы, Aggregate Functions, Subquery Expressions, Row and Array Comparisons

anyarray, Псевдо-типы

anyelement, Псевдо-типы

applicable role, applicable_roles

archive_command configuration parameter, Archiving

area, Geometric Functions and Operators

ARRAY, Array Constructors, Arrays

constant, Array Value Input

constructor, Array Constructors

determination of result type, UNION, CASE, and Related Constructs

of user-defined type, User-Defined Types

array_nulls configuration parameter, Previous PostgreSQL Versions

ascii, String Functions and Operators

asin, Mathematical Functions and Operators

AT TIME ZONE, AT TIME ZONE

atan, Mathematical Functions and Operators

atan2, Mathematical Functions and Operators

authentication_timeout configuration parameter, Security and Authentication

auto-increment

see serial

autocommit

bulk-loading data, Disable Autocommit

psql, Variables

autovacuum

configuration parameters, Automatic Vacuuming

general information, The auto-vacuum daemon

table-specific configuration, pg_autovacuum

autovacuum configuration parameter, Automatic Vacuuming

autovacuum_analyze_scale_factor configuration parameter, Automatic Vacuuming

autovacuum_analyze_threshold configuration parameter, Automatic Vacuuming

autovacuum_naptime configuration parameter, Automatic Vacuuming

autovacuum_vacuum_cost_delay configuration parameter, Automatic Vacuuming

autovacuum_vacuum_cost_limit configuration parameter, Automatic Vacuuming

autovacuum_vacuum_scale_factor configuration parameter, Automatic Vacuuming

autovacuum_vacuum_threshold configuration parameter, Automatic Vacuuming

average, Агрегатные функции, Aggregate Functions

B

B-tree

see index

backslash_quote configuration parameter, Previous PostgreSQL Versions

backup, System Administration Functions, Backup and Restore

base type, Система типов PostgreSQL

BEGIN, BEGIN

BETWEEN, Comparison Operators

BETWEEN SYMETRIC, Comparison Operators

bgwriter_all_maxpages configuration parameter, Background Writer

bgwriter_all_percent configuration parameter, Background Writer

bgwriter_delay configuration parameter, Background Writer

bgwriter_lru_maxpages configuration parameter, Background Writer

bgwriter_lru_percent configuration parameter, Background Writer

bigint, Числовые константы, Целочисленные типы

bigserial, Серийные типы

binary data, Двоичные типы данных

functions, Binary String Functions and Operators

binary string

concatenation, Binary String Functions and Operators

length, Binary String Functions and Operators

bison, Требования

bit string

constant, Битово-строковые константы

data type, Типы битовых строк

bit strings

functions, Bit String Functions and Operators

bitmap scan, Combining Multiple Indexes, Planner Method Configuration

bit_and, Aggregate Functions

bit_length, String Functions and Operators

bit_or, Aggregate Functions

BLOB

see large object

block_size configuration parameter, Preset Options

bonjour_name configuration parameter, Connection Settings

Boolean

data type, Логический тип

operators

see operators, logical

bool_and, Aggregate Functions

bool_or, Aggregate Functions

booting

starting the server during, Starting the Database Server

box (data type), Боксы

BSD/OS

IPC configuration, Shared Memory and Semaphores

shared library, Compiling and Linking Dynamically-Loaded Functions

btrim, String Functions and Operators

bytea, Двоичные типы данных

in libpq, Escaping Binary Strings for Inclusion in SQL Commands

C

C, libpq - C Library, ECPG - Embedded SQL in C

canceling

SQL command, Cancelling Queries in Progress

CASCADE

with DROP, Отслеживание зависимости

foreign key action, Внешние ключи

действие внешнего ключа, Внешние ключи

CASE, Conditional Expressions

determination of result type, UNION, CASE, and Related Constructs

case sensitivity

of SQL commands, Идентификаторы и ключевые слова

cbrt, Mathematical Functions and Operators

ceiling, Mathematical Functions and Operators

center, Geometric Functions and Operators

char, Символьные типы

character, Символьные типы

character set, Locale and Formatting, Preset Options, Character Set Support

character string

concatenation, String Functions and Operators

constant, Строковые константы

data types, Символьные типы

length, String Functions and Operators

character varying, Символьные типы

char_length, String Functions and Operators

check constraint, Ограничения Check

checkpoint, WAL Configuration, CHECKPOINT

checkpoint_segments configuration parameter, Checkpoints

checkpoint_timeout configuration parameter, Checkpoints

checkpoint_warning configuration parameter, Checkpoints

check_function_bodies configuration parameter, Statement Behavior

chr, String Functions and Operators

cid, Типы идентификаторов объектов

cidr, cidr

circle, Круги

client authentication, Client Authentication

timeout during, Security and Authentication

client_encoding configuration parameter, Locale and Formatting

client_min_messages configuration parameter, When To Log

clock_timestamp, Date/Time Functions and Operators

CLOSE, CLOSE

CLUSTER, CLUSTER

of databases

see database cluster

clusterdb, clusterdb

cmax, Системные колонки

cmin, Системные колонки

COALESCE, COALESCE

column, Концепции, Основы таблиц

adding, Добавление колонки

removing, Удаление колонки

renaming, Переименование колонки

system column, Системные колонки

column data type

changing, Изменение типа данных колонки

column reference, Ссылки на колонку

col_description, System Information Functions

COMMENT, COMMENT

about database objects, System Information Functions

in SQL, Комментарии

COMMIT, COMMIT

COMMIT PREPARED, COMMIT PREPARED

commit_delay configuration parameter, Settings

commit_siblings configuration parameter, Settings

comparison

operators, Comparison Operators

row-wise, Row and Array Comparisons

subquery result row, Subquery Expressions

compiling

libpq applications, Building libpq Programs

composite type, Composite Types, Система типов PostgreSQL

constant, Composite Value Input

constructor, Row Constructors

computed field, SQL Functions on Composite Types

concurrency, Concurrency Control

conditional expression, Conditional Expressions

configuration

of the server, Server Configuration

of the server

functions, System Administration Functions

configure, Процедура установки

config_file configuration parameter, File Locations

conjunction, Logical Operators

connection service file, The Connection Service File

constant, Константы

constraint, Ограничения целостности

adding, Добавление ограничения

check, Ограничения Check

foreign key, Внешние ключи

name, Ограничения Check

NOT NULL, Ограничения не-Null

primary key, Первичные ключи

removing, Удаление ограничения

unique, Ограничения уникальности

constraint exclusion, Разделение и исключение ограничений целостности, Other Planner Options

constraint_exclusion configuration parameter, Other Planner Options

CONTINUE

in PL/pgSQL, CONTINUE

continuous archiving, Backup and Restore

convert, String Functions and Operators

COPY, Заполнение таблицы записями, COPY

with libpq, Functions Associated with the COPY Command

cos, Mathematical Functions and Operators

cot, Mathematical Functions and Operators

count, Агрегатные функции

cpu_index_tuple_cost configuration parameter, Planner Cost Constants

cpu_operator_cost configuration parameter, Planner Cost Constants

cpu_tuple_cost configuration parameter, Planner Cost Constants

CREATE DATABASE, Creating a Database

CREATE AGGREGATE, CREATE AGGREGATE

CREATE CAST, CREATE CAST

CREATE CONSTRAINT, CREATE CONSTRAINT TRIGGER

CREATE CONVERSION, CREATE CONVERSION

CREATE DATABASE, CREATE DATABASE

CREATE DOMAIN, CREATE DOMAIN

CREATE FUNCTION, CREATE FUNCTION

CREATE GROUP, CREATE GROUP

CREATE INDEX, CREATE INDEX

CREATE LANGUAGE, CREATE LANGUAGE

CREATE OPERATOR, CREATE OPERATOR

CREATE OPERATOR CLASS, CREATE OPERATOR CLASS

CREATE ROLE, Database Roles, CREATE ROLE

CREATE RULE, CREATE RULE

CREATE SCHEMA, CREATE SCHEMA

CREATE SEQUENCE, CREATE SEQUENCE

CREATE TABLE, Создание новой таблицы, CREATE TABLE

CREATE TABLE AS, CREATE TABLE AS

CREATE TABLESPACE, Tablespaces, CREATE TABLESPACE

CREATE TRIGGER, CREATE TRIGGER

CREATE TYPE, CREATE TYPE

CREATE USER, CREATE USER

CREATE VIEW, CREATE VIEW

createdb, Создание базы данных, Creating a Database, createdb

createlang, createlang

createuser, Database Roles, createuser

cross join, Объдиненённые таблицы

crypt, Password authentication

cstring, Псевдо-типы

ctid, Системные колонки, View Rules in Non-SELECT Statements

current_date, Date/Time Functions and Operators

current_time, Date/Time Functions and Operators

current_timestamp, Date/Time Functions and Operators

currval, Sequence Manipulation Functions

cursor

CLOSE, CLOSE

DECLARE, DECLARE

FETCH, FETCH

in PL/pgSQL, Cursors

MOVE, MOVE

showing the query plan, EXPLAIN

custom_variable_classes configuration parameter, Customized Options

D

data area

see database cluster

data type, Типы данных

base, Система типов PostgreSQL

category, Overview

composite type, Система типов PostgreSQL

constant, Константы и другие типы

conversion, Type Conversion

internal organization, Base Types in C-Language Functions

numeric, Числовые типы

type cast, Type Casts

user-defined, User-Defined Types

database, Managing Databases

privilege to create, Role Attributes

database activity

monitoring, Monitoring Database Activity

database cluster, Концепции, Creating a Database Cluster

data_directory configuration parameter, File Locations

date, Типы дата/времени, Даты

constants, Специальные значения

current, Current Date/Time

output format, Вывод даты/времени

see also formatting

DateStyle configuration parameter, Locale and Formatting

date_part, Date/Time Functions and Operators, EXTRACT, date_part

date_trunc, Date/Time Functions and Operators, date_trunc

DBI, Database Access from PL/Perl

db_user_namespace configuration parameter, Security and Authentication

deadlock, Deadlocks

timeout during, Lock Management

deadlock_timeout configuration parameter, Lock Management

DEALLOCATE, DEALLOCATE

debug_assertions configuration parameter, Developer Options

debug_pretty_print configuration parameter, What To Log

debug_print_parse configuration parameter, What To Log

debug_print_plan configuration parameter, What To Log

debug_print_rewritten configuration parameter, What To Log

decimal

see numeric

DECLARE, DECLARE

decode, String Functions and Operators

default value, Значения по умолчанию

changing, Изменение значения по умолчанию для колонки

default_statistics_target configuration parameter, Other Planner Options

default_tablespace configuration parameter, Statement Behavior

default_transaction_isolation configuration parameter, Statement Behavior

default_transaction_read_only configuration parameter, Statement Behavior

default_with_oids configuration parameter, Previous PostgreSQL Versions

degrees, Mathematical Functions and Operators

delay, Delaying Execution

DELETE, Удаление данных из таблиц, Удаление данных, DELETE

diameter, Geometric Functions and Operators

Digital UNIX

see Tru64 UNIX

dirty read, Transaction Isolation

disjunction, Logical Operators

disk drive, WAL Internals

disk space, Recovering disk space

disk usage, Определение использования диска

DISTINCT, Запросы к таблицам, DISTINCT

dollar quoting, Константы, заключенные в знаках доллара

double precision, Типы с плавающей точкой

DROP AGGREGATE, DROP AGGREGATE

DROP CAST, DROP CAST

DROP CONVERSION, DROP CONVERSION

DROP DATABASE, Destroying a Database, DROP DATABASE

DROP DOMAIN, DROP DOMAIN

DROP FUNCTION, DROP FUNCTION

DROP GROUP, DROP GROUP

DROP INDEX, DROP INDEX

DROP LANGUAGE, DROP LANGUAGE

DROP OPERATOR, DROP OPERATOR

DROP OPERATOR CLASS, DROP OPERATOR CLASS

DROP OWNED, DROP OWNED

DROP ROLE, Database Roles, DROP ROLE

DROP RULE, DROP RULE

DROP SCHEMA, DROP SCHEMA

DROP SEQUENCE, DROP SEQUENCE

DROP TABLE, Создание новой таблицы, DROP TABLE

DROP TABLESPACE, DROP TABLESPACE

DROP TRIGGER, DROP TRIGGER

DROP TYPE, DROP TYPE

DROP USER, DROP USER

DROP VIEW, DROP VIEW

dropdb, Destroying a Database, dropdb

droplang, droplang

dropuser, Database Roles, dropuser

duplicate, Запросы к таблицам

duplicates, DISTINCT

dynamic loading, Other Defaults, Dynamic Loading

dynamic_library_path, Dynamic Loading

dynamic_library_path configuration parameter, Other Defaults

E

ECPG, ECPG - Embedded SQL in C, ecpg

effective_cache_size configuration parameter, Planner Cost Constants

elog, Reporting Errors Within the Server

in PL/Perl, Database Access from PL/Perl

in PL/Python, Database Access

in PL/Tcl, Database Access from PL/Tcl

embedded SQL

in C, ECPG - Embedded SQL in C

enabled role, enabled_roles

enable_bitmapscan configuration parameter, Planner Method Configuration

enable_hashagg configuration parameter, Planner Method Configuration

enable_hashjoin configuration parameter, Planner Method Configuration

enable_indexscan configuration parameter, Planner Method Configuration

enable_mergejoin configuration parameter, Planner Method Configuration

enable_nestloop configuration parameter, Planner Method Configuration

enable_seqscan configuration parameter, Planner Method Configuration

enable_sort configuration parameter, Planner Method Configuration

enable_tidscan configuration parameter, Planner Method Configuration

encode, String Functions and Operators

encryption, Encryption Options

END, END

environment variable, Environment Variables

ereport, Reporting Errors Within the Server

error codes

libpq, Main Functions

list of, PostgreSQL Error Codes

error message, Connection Status Functions

escape_string_warning configuration parameter, Previous PostgreSQL Versions

escaping strings, Escaping Strings for Inclusion in SQL Commands

every, Aggregate Functions

EXCEPT, Combining Queries

exceptions

in PL/PgSQL, Trapping Errors

EXECUTE, EXECUTE

EXISTS, Subquery Expressions

EXIT

in PL/pgSQL, EXIT

exp, Mathematical Functions and Operators

EXPLAIN, Using EXPLAIN, EXPLAIN

explain_pretty_print configuration parameter, Other Defaults

expression

order of evaluation, Expression Evaluation Rules

syntax, Выражения, возвращающие одиночное значение

extending SQL, Расширенный SQL

extensions, Расширения

external_pid_file configuration parameter, File Locations

extract, Date/Time Functions and Operators, EXTRACT, date_part

extra_float_digits configuration parameter, Locale and Formatting

F

false, Логический тип

FAQ-Liste, Прочая информация

fast path, The Fast-Path Interface

FETCH, FETCH

field

computed, SQL Functions on Composite Types

field selection, Field Selection

flex, Требования

float4

see real

float8

see double precision

floating point, Типы с плавающей точкой

floating-point

display, Locale and Formatting

floor, Mathematical Functions and Operators

foreign key, Внешние ключи

formatting, Data Type Formatting Functions

format_type, System Information Functions

free space map, Free Space Map

FreeBSD

IPC configuration, Shared Memory and Semaphores

shared library, Compiling and Linking Dynamically-Loaded Functions

start script, Starting the Database Server

FROM

missing, Previous PostgreSQL Versions

from_collapse_limit configuration parameter, Other Planner Options

fsync configuration parameter, Settings

full_page_writes configuration parameter, Settings

function, Functions and Operators

in the FROM clause, Table Functions

internal, Internal Functions

invocation, Function Calls

output parameter, Functions with Output Parameters

polymorphic, Полимофмический тип

type resolution in an invocation, Functions

user-defined, User-Defined Functions

in C, C-Language Functions
in SQL, Query Language (SQL) Functions

G

generate_series, Set Returning Functions

genetic query optimization, Genetic Query Optimizer

GEQO

see genetic query optimization

geqo configuration parameter, Genetic Query Optimizer

geqo_effort configuration parameter, Genetic Query Optimizer

geqo_generations configuration parameter, Genetic Query Optimizer

geqo_pool_size configuration parameter, Genetic Query Optimizer

geqo_selection_bias configuration parameter, Genetic Query Optimizer

geqo_threshold configuration parameter, Genetic Query Optimizer

get_bit, Binary String Functions and Operators

get_byte, Binary String Functions and Operators

GiST

see index

global data

in PL/Python, PL/Python Functions

in PL/Tcl, Global Data in PL/Tcl

GRANT, Privileges, GRANT

GREATEST, GREATEST and LEAST

determination of result type, UNION, CASE, and Related Constructs

GROUP BY, Агрегатные функции, The GROUP BY and HAVING Clauses

grouping, The GROUP BY and HAVING Clauses

H

hash

see index

has_database_privilege, System Information Functions

has_function_privilege, System Information Functions

has_language_privilege, System Information Functions

has_schema_privilege, System Information Functions

has_tablespace_privilege, System Information Functions

has_table_privilege, System Information Functions

HAVING, Агрегатные функции, The GROUP BY and HAVING Clauses

hba_file configuration parameter, File Locations

height, Geometric Functions and Operators

hierarchical database, Концепции

host name, Database Connection Control Functions

HP-UX

IPC configuration, Shared Memory and Semaphores

shared library, Compiling and Linking Dynamically-Loaded Functions

I

ident, Ident-based authentication

identifier

length, Идентификаторы и ключевые слова

syntax of, Идентификаторы и ключевые слова

ident_file configuration parameter, File Locations

IFNULL, COALESCE

ignore_system_indexes configuration parameter, Developer Options

IMMUTABLE, Function Volatility Categories

IN, Subquery Expressions, Row and Array Comparisons

include

in configuration file, Setting Parameters

index, Indexes

B-tree, Index Types

combining multiple indexes, Combining Multiple Indexes

examining usage, Examining Index Usage

on expressions, Indexes on Expressions

for user-defined data type, Interfacing Extensions To Indexes

GiST, Index Types, GiST Indexes

hash, Index Types

locks, Locking and Indexes

multicolumn, Multicolumn Indexes

partial, Partial Indexes

unique, Unique Indexes

index scan, Planner Method Configuration

inet (data type), inet

inet (тип данных), inet

inet_client_addr, System Information Functions

inet_client_port, System Information Functions

inet_server_addr, System Information Functions

inet_server_port, System Information Functions

information schema, The Information Schema

inheritance, Наследование, Previous PostgreSQL Versions

initcap, String Functions and Operators

initdb, Creating a Database Cluster, initdb

input function, User-Defined Types

of a data type, User-Defined Types

INSERT, Заполнение таблицы записями, Вставка данных, INSERT

inserting, Вставка данных

installation

on Windows, Требования, Установка клиента на Windows

instr, Porting Examples

int2

see smallint

int4

see integer

int8

see bigint

integer, Числовые константы, Целочисленные типы

integer_datetimes configuration parameter, Preset Options

interfaces, Отдельно разрабатываемые интерфейсы

internal, Псевдо-типы

INTERSECT, Combining Queries

interval, Типы дата/времени, Интервалы

ipcclean, ipcclean

IRIX

shared library, Compiling and Linking Dynamically-Loaded Functions

IS DISTINCT FROM, Comparison Operators, Row and Array Comparisons

IS FALSE, Comparison Operators

IS NOT DISTINCT FROM, Comparison Operators, Row and Array Comparisons

IS NOT FALSE, Comparison Operators

IS NOT NULL, Comparison Operators, Row and Array Comparisons

IS NOT TRUE, Comparison Operators

IS NOT UNKNOWN, Comparison Operators

IS NULL, Comparison Operators, Row and Array Comparisons, Platform and Client Compatibility

IS TRUE, Comparison Operators

IS UNKNOWN, Comparison Operators

isclosed, Geometric Functions and Operators

isfinite, Date/Time Functions and Operators

ISNULL, Comparison Operators

isopen, Geometric Functions and Operators

J

join, Объединения таблиц (Join), Объдиненённые таблицы

controlling the order, Controlling the Planner with Explicit JOIN Clauses

cross, Объдиненённые таблицы

left, Объдиненённые таблицы

natural, Объдиненённые таблицы

outer, Объединения таблиц (Join), Объдиненённые таблицы

right, Объдиненённые таблицы

self, Объединения таблиц (Join)

join_collapse_limit configuration parameter, Other Planner Options

justify_days, Date/Time Functions and Operators

justify_hours, Date/Time Functions and Operators

justify_interval, Date/Time Functions and Operators

K

Kerberos, Kerberos authentication

key word

list of, SQL Key Words

syntax of, Идентификаторы и ключевые слова

krb_caseins_users configuration parameter, Security and Authentication

krb_server_hostname configuration parameter, Security and Authentication

krb_server_keyfile configuration parameter, Security and Authentication

krb_srvname configuration parameter, Security and Authentication

L

label

see alias

language_handler, Псевдо-типы

large object, Large Objects

lastval, Sequence Manipulation Functions

lc_collate configuration parameter, Preset Options

lc_ctype configuration parameter, Preset Options

lc_messages configuration parameter, Locale and Formatting

lc_monetary configuration parameter, Locale and Formatting

lc_numeric configuration parameter, Locale and Formatting

lc_time configuration parameter, Locale and Formatting

LDAP, Процедура установки, LDAP authentication

LDAP connection parameter lookup, LDAP Lookup of Connection Parameters

ldconfig, Динамические библиотеки

LEAST, GREATEST and LEAST

determination of result type, UNION, CASE, and Related Constructs

left join, Объдиненённые таблицы

length, Geometric Functions and Operators

of a binary string

see binary strings, length

of a character string

see character string, length

libperl, Требования

libpq, libpq - C Library

libpq-fe.h, libpq - C Library, Connection Status Functions

libpq-int.h, Connection Status Functions

libpython, Требования

LIKE, LIKE

and locales, Behavior

LIMIT, LIMIT and OFFSET

line segment, Сегменты линий

Linux

IPC configuration, Shared Memory and Semaphores

shared library, Compiling and Linking Dynamically-Loaded Functions

start script, Starting the Database Server

LISTEN, LISTEN

listen_addresses configuration parameter, Connection Settings

ln, Mathematical Functions and Operators

LOAD, LOAD

locale, Creating a Database Cluster, Locale Support

localtime, Date/Time Functions and Operators

localtimestamp, Date/Time Functions and Operators

lock, Explicit Locking, Table-Level Locks, LOCK

monitoring, Viewing Locks

log, Mathematical Functions and Operators

login privilege, Role Attributes

log_connections configuration parameter, What To Log

log_destination configuration parameter, Where To Log

log_directory configuration parameter, Where To Log

log_disconnections configuration parameter, What To Log

log_duration configuration parameter, What To Log

log_error_verbosity configuration parameter, When To Log

log_executor_stats configuration parameter, Statistics Monitoring

log_filename configuration parameter, Where To Log

log_hostname configuration parameter, What To Log

log_line_prefix configuration parameter, What To Log

log_min_duration_statement configuration parameter, When To Log

log_min_error_statement configuration parameter, When To Log

log_min_messages configuration parameter, When To Log

log_parser_stats configuration parameter, Statistics Monitoring

log_planner_stats configuration parameter, Statistics Monitoring

log_rotation_age configuration parameter, Where To Log

log_rotation_size configuration parameter, Where To Log

log_statement configuration parameter, What To Log

log_statement_stats configuration parameter, Statistics Monitoring

log_truncate_on_rotation configuration parameter, Where To Log

loop

in PL/pgSQL, Simple Loops

lower, String Functions and Operators

and locales, Behavior

lo_close, Closing a Large Object Descriptor

lo_creat, Creating a Large Object, Server-Side Functions

lo_create, Creating a Large Object, Server-Side Functions

lo_export, Exporting a Large Object, Server-Side Functions

lo_import, Importing a Large Object, Server-Side Functions

lo_lseek, Seeking in a Large Object

lo_open, Opening an Existing Large Object

lo_read, Reading Data from a Large Object

lo_tell, Obtaining the Seek Position of a Large Object

lo_unlink, Removing a Large Object, Server-Side Functions

lo_write, Writing Data to a Large Object

lpad, String Functions and Operators

lseg, Сегменты линий

ltrim, String Functions and Operators

M

MAC address

see macaddr

MAC адрес

see macaddr

macaddr (data type), macaddr

macaddr (тип данных), macaddr

MacOS X

IPC configuration, Shared Memory and Semaphores

shared library, Compiling and Linking Dynamically-Loaded Functions

maintenance, Routine Database Maintenance Tasks

maintenance_work_mem configuration parameter, Memory

make, Требования

MANPATH, Переменные окружения

max, Агрегатные функции

max_connections configuration parameter, Connection Settings

max_files_per_process configuration parameter, Kernel Resource Usage

max_fsm_pages configuration parameter, Free Space Map

max_fsm_relations configuration parameter, Free Space Map

max_function_args configuration parameter, Preset Options

max_identifier_length configuration parameter, Preset Options

max_index_keys configuration parameter, Preset Options

max_locks_per_transaction configuration parameter, Lock Management

max_prepared_transactions configuration parameter, Memory

max_stack_depth configuration parameter, Memory

md5, String Functions and Operators, Password authentication

memory context

in SPI, Memory Management

min, Агрегатные функции

mod, Mathematical Functions and Operators

monitoring

database activity, Monitoring Database Activity

MOVE, MOVE

MVCC, Introduction

N

name

qualified, Создание схемы

syntax of, Идентификаторы и ключевые слова

unqualified, Путь поиска схемы

natural join, Объдиненённые таблицы

natural объединение, Объдиненённые таблицы

negation, Logical Operators

NetBSD

IPC configuration, Shared Memory and Semaphores

shared library, Compiling and Linking Dynamically-Loaded Functions

start script, Starting the Database Server

network

data types, Типы сетевых адресов

nextval, Sequence Manipulation Functions

nonblocking connection, Database Connection Control Functions, Asynchronous Command Processing

nonrepeatable read, Transaction Isolation

NOT (operator), Logical Operators

NOT IN, Subquery Expressions, Row and Array Comparisons

not-null constraint, Ограничения не-Null

notice processing

in libpq, Notice Processing

notice processor, Notice Processing

notice receiver, Notice Processing

NOTIFY, NOTIFY

in libpq, Asynchronous Notification

NOTNULL, Comparison Operators

now, Date/Time Functions and Operators

npoints, Geometric Functions and Operators

null value

with check constraints, Ограничения Check

comparing, Comparison Operators

default value, Значения по умолчанию

in DISTINCT, DISTINCT

in libpq, Retrieving Query Result Information

in PL/Perl, PL/Perl Functions and Arguments

in PL/Python, PL/Python Functions

with unique constraints, Ограничения уникальности

NULLIF, NULLIF

number

constant, Числовые константы

numeric, Числовые константы

numeric (data type), Числа с заданной точностью

numeric (тип данных), Числа с заданной точностью

NVL, COALESCE

O

object identifier

data type, Типы идентификаторов объектов

object-oriented database, Концепции

obj_description, System Information Functions

octet_length, String Functions and Operators

OFFSET, LIMIT and OFFSET

oid, Типы идентификаторов объектов

column, Системные колонки

in libpq, Retrieving Result Information for Other Commands

колонка, Системные колонки

ONLY, Предложение FROM

opaque, Псевдо-типы

OpenBSD

IPC configuration, Shared Memory and Semaphores

shared library, Compiling and Linking Dynamically-Loaded Functions

start script, Starting the Database Server

OpenSSL, Процедура установки

see also SSL

operator, Functions and Operators

invocation, Operator Invocations

logical, Logical Operators

precedence, Лексические приоритеты

syntax, Оперторы

type resolution in an invocation, Operators

user-defined, User-Defined Operators

operator class, Operator Classes, Index Methods and Operator Classes

OR (operator), Logical Operators

Oracle

porting from PL/SQL to PL/pgSQL, Porting from Oracle PL/SQL

ORDER BY, Запросы к таблицам, Sorting Rows

and locales, Behavior

ordering operator, System Dependencies on Operator Classes

outer join, Объдиненённые таблицы

output function

of a data type, User-Defined Types

output function, User-Defined Types

overlay, String Functions and Operators

overloading

functions, Function Overloading

operators, User-Defined Operators

owner, Privileges

P

palloc, Writing Code

PAM, Процедура установки, PAM authentication

parameter

syntax, Позиционные параметры

parenthesis, Выражения, возвращающие одиночное значение

partitioning, Разделение

password, Role Attributes

authentication, Password authentication

of the superuser, Creating a Database Cluster

password file, The Password File

password_encryption configuration parameter, Security and Authentication

PATH, Переменные окружения

for schemas, Statement Behavior

path (data type), Пути

pattern matching, Pattern Matching

pclose, Geometric Functions and Operators

performance, Performance Tips

Perl, PL/Perl - Perl Procedural Language

permission

see privilege

pfree, Writing Code

PGcancel, Cancelling Queries in Progress

PGCLIENTENCODING, Environment Variables

PGconn, Database Connection Control Functions

PGCONNECT_TIMEOUT, Environment Variables

PGDATA, Creating a Database Cluster

PGDATABASE, Environment Variables

PGDATESTYLE, Environment Variables

PGGEQO, Environment Variables

PGHOST, Environment Variables

PGHOSTADDR, Environment Variables

PGKRBSRVNAME, Environment Variables

PGLOCALEDIR, Environment Variables

PGOPTIONS, Environment Variables

PGPASSFILE, Environment Variables

PGPASSWORD, Environment Variables

PGPORT, Environment Variables

PGREALM, Environment Variables

PGREQUIRESSL, Environment Variables

PGresult, Main Functions

PGSERVICE, Environment Variables

PGSSLMODE, Environment Variables

PGSYSCONFDIR, Environment Variables

PGTZ, Environment Variables

PGUSER, Environment Variables

pgxs, Extension Building Infrastructure

pg_aggregate, pg_aggregate

pg_am, pg_am

pg_amop, pg_amop

pg_amproc, pg_amproc

pg_attrdef, pg_attrdef

pg_attribute, pg_attribute

pg_authid, pg_authid

pg_auth_members, pg_auth_members

pg_autovacuum, pg_autovacuum

pg_cancel_backend, System Administration Functions

pg_cast, pg_cast

pg_class, pg_class

pg_client_encoding, String Functions and Operators

pg_column_size, System Administration Functions

pg_config, pg_config

with libpq, Building libpq Programs

with user-defined C functions, Writing Code

pg_constraint, pg_constraint

pg_controldata, pg_controldata

pg_conversion, pg_conversion

pg_conversion_is_visible, System Information Functions

pg_ctl, Starting the Database Server, pg_ctl

pg_cursors, pg_cursors

pg_database, Template Databases, pg_database

pg_database_size, System Administration Functions

pg_depend, pg_depend

pg_description, pg_description

pg_dump, pg_dump

pg_dumpall, pg_dumpall

use during upgrade, Если вы производите обновление

pg_function_is_visible, System Information Functions

pg_get_constraintdef, System Information Functions

pg_get_expr, System Information Functions

pg_get_indexdef, System Information Functions

pg_get_ruledef, System Information Functions

pg_get_serial_sequence, System Information Functions

pg_get_triggerdef, System Information Functions

pg_get_userbyid, System Information Functions

pg_get_viewdef, System Information Functions

pg_group, pg_group

pg_has_role, System Information Functions

pg_hba.conf, The pg_hba.conf file

pg_ident.conf, Ident Maps

pg_index, pg_index

pg_indexes, pg_indexes

pg_inherits, pg_inherits

pg_language, pg_language

pg_largeobject, pg_largeobject

pg_listener, pg_listener

pg_locks, pg_locks

pg_ls_dir, System Administration Functions

pg_namespace, pg_namespace

pg_opclass, pg_opclass

pg_opclass_is_visible, System Information Functions

pg_operator, pg_operator

pg_operator_is_visible, System Information Functions

pg_pltemplate, pg_pltemplate

pg_postmaster_start_time, System Information Functions

pg_prepared_statements, pg_prepared_statements

pg_prepared_xacts, pg_prepared_xacts

pg_proc, pg_proc

pg_read_file, System Administration Functions

pg_relation_size, System Administration Functions

pg_reload_conf, System Administration Functions

pg_restore, pg_restore

pg_rewrite, pg_rewrite

pg_roles, pg_roles

pg_rotate_logfile, System Administration Functions

pg_rules, pg_rules

pg_service.conf, The Connection Service File

pg_settings, pg_settings

pg_shadow, pg_shadow

pg_shdepend, pg_shdepend

pg_shdescription, pg_shdescription

pg_size_pretty, System Administration Functions

pg_sleep, Delaying Execution

pg_start_backup, System Administration Functions

pg_statistic, Statistics Used by the Planner, pg_statistic

pg_stats, Statistics Used by the Planner, pg_stats

pg_stat_file, System Administration Functions

pg_stop_backup, System Administration Functions

pg_tables, pg_tables

pg_tablespace, pg_tablespace

pg_tablespace_databases, System Information Functions

pg_tablespace_size, System Administration Functions

pg_table_is_visible, System Information Functions

pg_timezonenames, pg_timezonenames

pg_total_relation_size, System Administration Functions

pg_trigger, pg_trigger

pg_type, pg_type

pg_type_is_visible, System Information Functions

pg_user, pg_user

pg_views, pg_views

phantom read, Transaction Isolation

PIC, Compiling and Linking Dynamically-Loaded Functions

PID

determining PID of server process

in libpq, Connection Status Functions

PITR, Backup and Restore

PL/Perl, PL/Perl - Perl Procedural Language

PL/PerlU, Trusted and Untrusted PL/Perl

PL/pgSQL, PL/pgSQL - SQL Procedural Language

PL/Python, PL/Python - Python Procedural Language

PL/SQL (Oracle)

porting to PL/pgSQL, Porting from Oracle PL/SQL

PL/Tcl, PL/Tcl - Tcl Procedural Language

point, Точки

point-in-time recovery, Backup and Restore

polygon, Полигоны

polymorphic function, Полимофмический тип

polymorphic type, Полимофмический тип

popen, Geometric Functions and Operators

port, Database Connection Control Functions

port configuration parameter, Connection Settings

position, String Functions and Operators

POSTGRES, Проект POSTGRES департамента Беркли, Фундаментальные основы архитектуры, Starting the Database Server, Creating a Database, postgres

postgres user, The PostgreSQL User Account

Postgres95, Postgres95

postgresql.conf, Setting Parameters

postmaster, postmaster

post_auth_delay configuration parameter, Developer Options

power, Mathematical Functions and Operators

PQbackendPID, Connection Status Functions

PQbinaryTuples, Retrieving Query Result Information

with COPY, Functions Associated with the COPY Command

PQcancel, Cancelling Queries in Progress

PQclear, Main Functions

PQcmdStatus, Retrieving Result Information for Other Commands

PQcmdTuples, Retrieving Result Information for Other Commands

PQconndefaults, Database Connection Control Functions

PQconnectdb, Database Connection Control Functions

PQconnectPoll, Database Connection Control Functions

PQconnectStart, Database Connection Control Functions

PQconsumeInput, Asynchronous Command Processing

PQdb, Connection Status Functions

PQencryptPassword, Miscellaneous Functions

PQendcopy, Obsolete Functions for COPY

PQerrorMessage, Connection Status Functions

PQescapeBytea, Escaping Binary Strings for Inclusion in SQL Commands

PQescapeByteaConn, Escaping Binary Strings for Inclusion in SQL Commands

PQescapeString, Escaping Strings for Inclusion in SQL Commands

PQescapeStringConn, Escaping Strings for Inclusion in SQL Commands

PQexec, Main Functions

PQexecParams, Main Functions

PQexecPrepared, Main Functions

PQfformat, Retrieving Query Result Information

with COPY, Functions Associated with the COPY Command

PQfinish, Database Connection Control Functions

PQflush, Asynchronous Command Processing

PQfmod, Retrieving Query Result Information

PQfn, The Fast-Path Interface

PQfname, Retrieving Query Result Information

PQfnumber, Retrieving Query Result Information

PQfreeCancel, Cancelling Queries in Progress

PQfreemem, Escaping Binary Strings for Inclusion in SQL Commands

PQfsize, Retrieving Query Result Information

PQftable, Retrieving Query Result Information

PQftablecol, Retrieving Query Result Information

PQftype, Retrieving Query Result Information

PQgetCancel, Cancelling Queries in Progress

PQgetCopyData, Functions for Receiving COPY Data

PQgetisnull, Retrieving Query Result Information

PQgetlength, Retrieving Query Result Information

PQgetline, Obsolete Functions for COPY

PQgetlineAsync, Obsolete Functions for COPY

PQgetResult, Asynchronous Command Processing

PQgetssl, Connection Status Functions

PQgetvalue, Retrieving Query Result Information

PQhost, Connection Status Functions

PQisBusy, Asynchronous Command Processing

PQisnonblocking, Asynchronous Command Processing

PQisthreadsafe, Behavior in Threaded Programs

PQmakeEmptyPGresult, Main Functions

PQnfields, Retrieving Query Result Information

with COPY, Functions Associated with the COPY Command

PQnotifies, Asynchronous Notification

PQntuples, Retrieving Query Result Information

PQoidStatus, Retrieving Result Information for Other Commands

PQoidValue, Retrieving Result Information for Other Commands

PQoptions, Connection Status Functions

PQparameterStatus, Connection Status Functions

PQpass, Connection Status Functions

PQport, Connection Status Functions

PQprepare, Main Functions

PQprint, Retrieving Query Result Information

PQprotocolVersion, Connection Status Functions

PQputCopyData, Functions for Sending COPY Data

PQputCopyEnd, Functions for Sending COPY Data

PQputline, Obsolete Functions for COPY

PQputnbytes, Obsolete Functions for COPY

PQrequestCancel, Cancelling Queries in Progress

PQreset, Database Connection Control Functions

PQresetPoll, Database Connection Control Functions

PQresetStart, Database Connection Control Functions

PQresStatus, Main Functions

PQresultErrorField, Main Functions

PQresultErrorMessage, Main Functions

PQresultStatus, Main Functions

PQsendPrepare, Asynchronous Command Processing

PQsendQuery, Asynchronous Command Processing

PQsendQueryParams, Asynchronous Command Processing

PQsendQueryPrepared, Asynchronous Command Processing

PQserverVersion, Connection Status Functions

PQsetdb, Database Connection Control Functions

PQsetdbLogin, Database Connection Control Functions

PQsetErrorVerbosity, Control Functions

PQsetnonblocking, Asynchronous Command Processing

PQsetNoticeProcessor, Notice Processing

PQsetNoticeReceiver, Notice Processing

PQsocket, Connection Status Functions

PQstatus, Connection Status Functions

PQtrace, Control Functions

PQtransactionStatus, Connection Status Functions

PQtty, Connection Status Functions

PQunescapeBytea, Escaping Binary Strings for Inclusion in SQL Commands

PQuntrace, Control Functions

PQuser, Connection Status Functions

predicate locking, Serializable Isolation versus True Serializability

preload_libraries configuration parameter, Kernel Resource Usage

PREPARE, PREPARE

PREPARE TRANSACTION, PREPARE TRANSACTION

prepared statements

creating, PREPARE

executing, EXECUTE

removing, DEALLOCATE

showing the query plan, EXPLAIN

preparing a query

in PL/Tcl, Database Access from PL/Tcl

in PL/pgSQL, Overview

in PL/Python, Database Access

pre_auth_delay configuration parameter, Developer Options

primary key, Первичные ключи

privilege, Привилегии, Privileges

querying, System Information Functions

with rules, Rules and Privileges

for schemas, Схемы и привилегии

with views, Rules and Privileges

procedural language, Procedural Languages

handler for, Writing A Procedural Language Handler

ps

to monitor activity, Standard Unix Tools

psql, Доступ к базе данных, psql

Python, PL/Python - Python Procedural Language

Q

qualified name, Создание схемы

query, Запросы к таблицам, Запросы

query plan, Using EXPLAIN

query tree, The Query Tree

quotation marks

and identifiers, Идентификаторы и ключевые слова

escaping, Строковые константы

quote_ident, String Functions and Operators

use in PL/PgSQL, Executing Dynamic Commands

quote_literal, String Functions and Operators

use in PL/PgSQL, Executing Dynamic Commands

R

radians, Mathematical Functions and Operators

radius, Geometric Functions and Operators

RAISE, Errors and Messages

random, Mathematical Functions and Operators

random_page_cost configuration parameter, Planner Cost Constants

range table, The Query Tree

read-only transaction, Statement Behavior

readline, Требования

real, Типы с плавающей точкой

REASSIGN OWNED, REASSIGN OWNED

record, Псевдо-типы

rectangle, Боксы

redirect_stderr configuration parameter, Where To Log

referential integrity, Внешние ключи

regclass, Типы идентификаторов объектов

regexp_replace, SIMILAR TO Regular Expressions

regex_flavor configuration parameter, Previous PostgreSQL Versions

regoper, Типы идентификаторов объектов

regoperator, Типы идентификаторов объектов

regproc, Типы идентификаторов объектов

regprocedure, Типы идентификаторов объектов

regression tests, Regression Tests

regtype, Типы идентификаторов объектов

regular expression, SIMILAR TO Regular Expressions, POSIX Regular Expressions

see also pattern matching

regular expressions, Previous PostgreSQL Versions

reindex, Routine Reindexing, REINDEX

reindexdb, reindexdb

relation, Концепции

relational database, Концепции

RELEASE SAVEPOINT, RELEASE SAVEPOINT

repeat, String Functions and Operators

replace, String Functions and Operators

reporting errors

in PL/PgSQL, Errors and Messages

RESET, RESET

RESTRICT

with DROP, Отслеживание зависимости

foreign key action, Внешние ключи

действие внешнего ключа, Внешние ключи

REVOKE, Privileges, REVOKE

right join, Объдиненённые таблицы

role, Database Roles

applicable, applicable_roles

enabled, enabled_roles

membership in, Role Membership

privilege to create, Role Attributes

ROLLBACK, ROLLBACK

psql, Variables

ROLLBACK PREPARED, ROLLBACK PREPARED

ROLLBACK TO SAVEPOINT, ROLLBACK TO SAVEPOINT

round, Mathematical Functions and Operators

row, Концепции, Row Constructors, Основы таблиц

row estimation

planner, Row Estimation Examples

row type, Composite Types

constructor, Row Constructors

row-wise comparison, Row and Array Comparisons

rpad, String Functions and Operators

rtrim, String Functions and Operators

rule, The Rule System

and views, Views and the Rule System

for DELETE, Rules on INSERT, UPDATE, and DELETE

for INSERT, Rules on INSERT, UPDATE, and DELETE

for SELECT, How SELECT Rules Work

compared with triggers, Rules versus Triggers

for UPDATE, Rules on INSERT, UPDATE, and DELETE

S

SAVEPOINT, SAVEPOINT

savepoints

defining, SAVEPOINT

releasing, RELEASE SAVEPOINT

rolling back, ROLLBACK TO SAVEPOINT

scalar

see expression

schema, Схемы, Overview

creating, Создание схемы

current, Путь поиска схемы, System Information Functions

removing, Создание схемы

SCO OpenServer

IPC configuration, Shared Memory and Semaphores

search path, Путь поиска схемы

current, System Information Functions

search_path, Путь поиска схемы

search_path configuration parameter, Statement Behavior

SELECT, Запросы к таблицам, Запросы, SELECT

select list, Select Lists

SELECT INTO, SELECT INTO

in PL/pgSQL, SELECT INTO

semaphores, Shared Memory and Semaphores

sequence, Sequence Manipulation Functions

and serial type, Серийные типы

sequential scan, Planner Method Configuration

seq_page_cost configuration parameter, Planner Cost Constants

serial, Серийные типы

serial4, Серийные типы

serial8, Серийные типы

serializability, Serializable Isolation versus True Serializability

server log, Error Reporting and Logging

log file maintenance, Log File Maintenance

server_encoding configuration parameter, Preset Options

server_version configuration parameter, Preset Options

SET, System Administration Functions, SET

SET CONSTRAINTS, SET CONSTRAINTS

set difference, Combining Queries

set intersection, Combining Queries

set operation, Combining Queries

set returning functions

functions, Set Returning Functions

SET ROLE, SET ROLE

SET SESSION AUTHORIZATION, SET SESSION AUTHORIZATION

SET TRANSACTION, SET TRANSACTION

set union, Combining Queries

SETOF, Query Language (SQL) Functions

see also function

setseed, Mathematical Functions and Operators

setval, Sequence Manipulation Functions

set_bit, Binary String Functions and Operators

set_byte, Binary String Functions and Operators

shared library, Динамические библиотеки, Compiling and Linking Dynamically-Loaded Functions

shared memory, Shared Memory and Semaphores

shared_buffers configuration parameter, Memory

SHMMAX, Shared Memory and Semaphores

shobj_description, System Information Functions

SHOW, System Administration Functions, SHOW

shutdown, Shutting Down the Server

SIGHUP, Setting Parameters, The pg_hba.conf file, Ident Maps

SIGINT, Shutting Down the Server

sign, Mathematical Functions and Operators

signal

backend processes, System Administration Functions

significant digits, Locale and Formatting

SIGQUIT, Shutting Down the Server

SIGTERM, Shutting Down the Server

silent_mode configuration parameter, When To Log

sin, Mathematical Functions and Operators

sleep, Delaying Execution

sliced bread

see TOAST

smallint, Целочисленные типы

Solaris

IPC configuration, Shared Memory and Semaphores

shared library, Compiling and Linking Dynamically-Loaded Functions

start script, Starting the Database Server

SOME, Aggregate Functions, Subquery Expressions, Row and Array Comparisons

sorting, Sorting Rows

SPI, Server Programming Interface

SPI_connect, SPI_connect

SPI_copytuple, SPI_copytuple

SPI_cursor_close, SPI_cursor_close

SPI_cursor_fetch, SPI_cursor_fetch

SPI_cursor_find, SPI_cursor_find

SPI_cursor_move, SPI_cursor_move

SPI_cursor_open, SPI_cursor_open

SPI_exec, SPI_exec

SPI_execp, SPI_execp

SPI_execute, SPI_execute

SPI_execute_plan, SPI_execute_plan

spi_exec_query

in PL/Perl, Database Access from PL/Perl

SPI_finish, SPI_finish

SPI_fname, SPI_fname

SPI_fnumber, SPI_fnumber

SPI_freeplan, SPI_freeplan

SPI_freetuple, SPI_freetuple

SPI_freetuptable, SPI_freetuptable

SPI_getargcount, SPI_getargcount

SPI_getargtypeid, SPI_getargtypeid

SPI_getbinval, SPI_getbinval

SPI_getnspname, SPI_getnspname

SPI_getrelname, SPI_getrelname

SPI_gettype, SPI_gettype

SPI_gettypeid, SPI_gettypeid

SPI_getvalue, SPI_getvalue

SPI_is_cursor_plan, SPI_is_cursor_plan

spi_lastoid, Database Access from PL/Tcl

SPI_modifytuple, SPI_modifytuple

SPI_palloc, SPI_palloc

SPI_pfree, SPI_pfree

SPI_pop, SPI_pop

SPI_prepare, SPI_prepare

SPI_push, SPI_push

SPI_repalloc, SPI_repalloc

SPI_returntuple, SPI_returntuple

SPI_saveplan, SPI_saveplan

split_part, String Functions and Operators

sql_inheritance configuration parameter, Previous PostgreSQL Versions

sqrt, Mathematical Functions and Operators

ssh, Secure TCP/IP Connections with SSH Tunnels

SSL, Secure TCP/IP Connections with SSL, SSL Support

with libpq, Database Connection Control Functions, Connection Status Functions

ssl configuration parameter, Security and Authentication

STABLE, Function Volatility Categories

standard deviation, Aggregate Functions

population, Aggregate Functions

sample, Aggregate Functions

standard_conforming_strings configuration parameter, Previous PostgreSQL Versions

START TRANSACTION, START TRANSACTION

statement_timeout configuration parameter, Statement Behavior

statement_timestamp, Date/Time Functions and Operators

statistics, The Statistics Collector

of the planner, Statistics Used by the Planner, Updating planner statistics

stats_block_level configuration parameter, Query and Index Statistics Collector

stats_command_string configuration parameter, Query and Index Statistics Collector

stats_reset_on_server_start configuration parameter, Query and Index Statistics Collector

stats_row_level configuration parameter, Query and Index Statistics Collector

stats_start_collector configuration parameter, Query and Index Statistics Collector

string

see character string

strings

backslash quotes, Previous PostgreSQL Versions

escape warning, Previous PostgreSQL Versions

standard conforming, Previous PostgreSQL Versions

strpos, String Functions and Operators

subquery, Scalar Subqueries, Subqueries, Subquery Expressions

subscript, Subscripts

substr, String Functions and Operators

substring, String Functions and Operators, Binary String Functions and Operators, SIMILAR TO Regular Expressions

sum, Агрегатные функции

superuser, Доступ к базе данных, Role Attributes

superuser_reserved_connections configuration parameter, Connection Settings

syntax

SQL, Ситаксис SQL

syslog_facility configuration parameter, Where To Log

syslog_identity configuration parameter, Where To Log

system catalog

schema, Схема системного каталога

T

table, Концепции, Основы таблиц

creating, Основы таблиц

inheritance, Наследование

modifying, Изменение таблиц

partitioning, Разделение

removing, Основы таблиц

renaming, Переименование таблицы

table expression, Табличные выражения

table function, Table Functions

tableoid, Системные колонки

tablespace, Tablespaces

default, Statement Behavior

tan, Mathematical Functions and Operators

target list, The Query Tree

Tcl, PL/Tcl - Tcl Procedural Language

tcp_keepalives_count configuration parameter, Connection Settings

tcp_keepalives_idle configuration parameter, Connection Settings

tcp_keepalives_interval configuration parameter, Connection Settings

template0, Template Databases

template1, Creating a Database, Template Databases

temp_buffers configuration parameter, Memory

test, Regression Tests

text, Символьные типы

threads

with libpq, Behavior in Threaded Programs

tid, Типы идентификаторов объектов

time, Типы дата/времени, Время

constants, Специальные значения

current, Current Date/Time

output format, Вывод даты/времени

see also formatting

time span, Типы дата/времени

time with time zone, Типы дата/времени, Время

time without time zone, Типы дата/времени, Время

time zone, Временные зоны, Locale and Formatting

configuration names, Date/Time Key Words

conversion, AT TIME ZONE

input abbreviations, Date/Time Key Words

time zone names, Locale and Formatting

timelines, Backup and Restore

timeofday, Date/Time Functions and Operators

timeout

client authentication, Security and Authentication

deadlock, Lock Management

timestamp, Типы дата/времени, Дата и время

timestamp with time zone, Типы дата/времени, Дата и время

timestamp without time zone, Типы дата/времени, Дата и время

timezone configuration parameter, Locale and Formatting

timezone_abbreviations configuration parameter, Locale and Formatting

TOAST, TOAST

and user-defined types, User-Defined Types

per-column storage settings, Description

versus large objects, Introduction

token, Лексическая структура

to_ascii, String Functions and Operators

to_char, Data Type Formatting Functions

and locales, Behavior

to_date, Data Type Formatting Functions

to_hex, String Functions and Operators

to_number, Data Type Formatting Functions

to_timestamp, Data Type Formatting Functions

trace_notify configuration parameter, Developer Options

trace_sort configuration parameter, Developer Options

transaction ID

wraparound, Preventing transaction ID wraparound failures

transaction isolation, Transaction Isolation

transaction isolation level, Transaction Isolation, Statement Behavior

read committed, Read Committed Isolation Level

serializable, Serializable Isolation Level

transaction log

see WAL

transaction_timestamp, Date/Time Functions and Operators

transform_null_equals configuration parameter, Platform and Client Compatibility

translate, String Functions and Operators

trigger, Псевдо-типы, Triggers

arguments for trigger functions, Overview of Trigger Behavior

in C, Writing Trigger Functions in C

in PL/pgSQL, Trigger Procedures

in PL/Python, Trigger Functions

in PL/Tcl, Trigger Procedures in PL/Tcl

compared with rules, Rules versus Triggers

trim, String Functions and Operators

Tru64 UNIX

shared library, Compiling and Linking Dynamically-Loaded Functions

true, Логический тип

trunc, Mathematical Functions and Operators

TRUNCATE, TRUNCATE

trusted

PL/Perl, Trusted and Untrusted PL/Perl

type

see data type
polymorphic, Полимофмический тип

type cast, Числовые константы, Type Casts

U

UNION, Combining Queries

determination of result type, UNION, CASE, and Related Constructs

unique constraint, Ограничения уникальности

Unix domain socket, Database Connection Control Functions

UnixWare

IPC configuration, Shared Memory and Semaphores

shared library, Compiling and Linking Dynamically-Loaded Functions

unix_socket_directory configuration parameter, Connection Settings

unix_socket_group configuration parameter, Connection Settings

unix_socket_permissions configuration parameter, Connection Settings

UNLISTEN, UNLISTEN

unqualified name, Путь поиска схемы

UPDATE, Обновление данных в таблицах, Обновление данных, UPDATE

update_process_title configuration parameter, Query and Index Statistics Collector

updating, Обновление данных

upgrading, Migration Between Releases

upper, String Functions and Operators

and locales, Behavior

user, Database Roles

current, System Information Functions

V

vacuum, Routine Vacuuming, VACUUM

vacuumdb, vacuumdb

vacuum_cost_delay configuration parameter, Cost-Based Vacuum Delay

vacuum_cost_limit configuration parameter, Cost-Based Vacuum Delay

vacuum_cost_page_dirty configuration parameter, Cost-Based Vacuum Delay

vacuum_cost_page_hit configuration parameter, Cost-Based Vacuum Delay

vacuum_cost_page_miss configuration parameter, Cost-Based Vacuum Delay

value expression, Выражения, возвращающие одиночное значение

varchar, Символьные типы

variance, Aggregate Functions

population, Aggregate Functions

sample, Aggregate Functions

version, Доступ к базе данных, System Information Functions

compatibility, Migration Between Releases

view

implementation through rules, Views and the Rule System

updating, Cooperation with Views

void, Псевдо-типы

VOLATILE, Function Volatility Categories

volatility

functions, Function Volatility Categories

W

WAL, Reliability and the Write-Ahead Log

wal_buffers configuration parameter, Settings

wal_debug configuration parameter, Developer Options

wal_sync_method configuration parameter, Settings

WHERE, The WHERE Clause

where to log, Where To Log

WHILE

in PL/pgSQL, WHILE

width, Geometric Functions and Operators

width_bucket, Mathematical Functions and Operators

work_mem configuration parameter, Memory

X

xid, Типы идентификаторов объектов
xmax, Системные колонки
xmin, Системные колонки

Y

yacc, Требования

Z

zero_damaged_pages configuration parameter, Developer Options
zlib, Требования, Процедура установки

Prev	Home
Библиография