색인
이전 위로PostgreSQL 13.3 문서처음으로 

색인

Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z

Symbols

$, Positional Parameters
$libdir, Dynamic Loading
$libdir/plugins, 공유 라이브러리 사전 로드, 설명
*, Select-List Items
.pgpass, The Password File
.pg_service.conf, The Connection Service File
::, Type Casts
_PG_fini, Dynamic Loading
_PG_init, Dynamic Loading
_PG_output_plugin_init, Initialization Function
객체지향형 데이터베이스, 개념
겹침
다중 트랜잭션, 다중 트랜잭션과 겹침
트랜잭션 ID, 트랜잭션 ID 겹침 오류 방지
계층형 데이터베이스, 개념
고가용성, 고가용성, 부하 분산, 복제
공유 메모리, 공유 메모리 및 세마포어
관계형 데이터베이스, 개념
관리, 정기적인 데이터베이스 관리 작업들
논리적 디코딩, 논리적 디코딩, 논리적 디코딩
다중 버전 동시성 제어, 소개
단일 사용자 모드, 단일 사용자 모드용 옵션
데이터 영역 (살펴볼 내용 데이터베이스 클러스터)
데이터베이스, 데이터베이스 관리
생성 권한, role 속성
데이터베이스 클러스터, 개념, 데이터베이스 클러스터 생성
동기식 복제, 고가용성, 부하 분산, 복제
디스크 사용량, 디스크 사용량 결정
디스크 여유 공간, 디스크 여유 공간 확보
로그인 권한, role 속성
로드 밸런싱, 고가용성, 부하 분산, 복제
로우, 개념
로케일, 로케일(Locale) 지원
리플리케이션, 고가용성, 부하 분산, 복제
릴레이션, 개념
모니터링, 데이터베이스 성능 모니터링
데이터베이스 서버, 데이터베이스 성능 모니터링
문자 집합, 문자 집합 지원
배열, 배열
검색, 배열 검색
수정, 배열 수정
저장, 배열값 저장
접근, 배열 접근
정의, 배열 타입 정의
백업, 백업과 복원
버전, PostgreSQL 클러스터 업그레이드
호환성, PostgreSQL 클러스터 업그레이드
병렬 쿼리, 병렬 쿼리
복제, 고가용성, 부하 분산, 복제
복제 슬롯
논리적 복제, 복제 슬롯
스트리밍 복제, 복제 슬롯
부팅
시 데이터베이스 서버 시작, 데이터베이스 서버 시작
부하 분산, 고가용성, 부하 분산, 복제
뷰, 뷰
비동기 커밋, 비동기 커밋
사용자, 데이터베이스 role
사용자 이름 맵, 사용자 이름 맵
상속, 상속
상시 대기, 고가용성, 부하 분산, 복제
서버 로그, 로그 파일 관리
로그 파일 관리, 로그 파일 관리
서버 스푸핑, 서버 스푸핑 방지
서브쿼리, 집계 함수
세마포어, 공유 메모리 및 세마포어
셧다운, 서버 셧다운
수퍼유저, role 속성
순차적 복제, 고가용성, 부하 분산, 복제
스키마, 개요
스토리지 매개 변수, 스토리지 매개 변수
스트리밍 복제, 고가용성, 부하 분산, 복제
아카이브 모드 백업, 백업과 복원
아카이브 연속성
대기서버, 대기 서버에서 아카이브 연속성 보장
암호화, 암호화 옵션, pgcrypto
특정 칼럼, pgcrypto
업그레이드, PostgreSQL 클러스터 업그레이드
업데이트 가능한 뷰, 업데이트 가능한 뷰
에러 코드, PostgreSQL에러 코드
목록, PostgreSQL에러 코드
연산자, 사용자 정의 연산자
사용자 정의, 사용자 정의 연산자
오버로드, 함수 오버로드
함수, 함수 오버로드
오버로딩
연산자, 사용자 정의 연산자
윈도우 함수, 윈도우 함수
유전 쿼리 최적화, 유전 쿼리 최적화
이동-집계 모드, 이동-집계 모드
이벤트 로그, Windows에 이벤트 로그 등록
이벤트 로그, Windows에 이벤트 로그 등록
인자 개수가 가변인 함수, SQL 함수에서 여러 인자를 입력하기
인증서, 인증서 인증
임의 코드 블럭, DO
장애처리, 고가용성, 부하 분산, 복제
정규식 표현
및 로케일, 동작
정기 관리, 정기적인 데이터베이스 관리 작업들
조인, 테이블 조인
직렬화가 가능한 스냅숏 격리, 소개
집계 함수, 집계 함수, 사용자 정의 집계 함수
가변 인자, 다형 자료형과 가변 인자 집계 함수
다형 자료형, 다형 자료형과 가변 인자 집계 함수
부분 집계, 부분 집계
사용자 정의, 사용자 정의 집계 함수
이동 집계, 이동-집계 모드
정렬된 집합, 정렬된-집합 집계 함수
함수 지원, 집계 함수용 함수 지원
참조 무결성, 참조키
참조키, 참조키
칼럼, 개념
커밋된 읽기, 커밋된 읽기 격리 수준
쿼리, 테이블에 있는 자료 조회하기
클라이언트 인증, 클라이언트 인증
timeout during, 인증
클러스터링, 고가용성, 부하 분산, 복제
키워드, SQL 키워드
목록, SQL 키워드
타임라인, 백업과 복원
테이블, 개념
테이블스페이스, Tablespaces
통계, 통계 수집기
통계 정보, 실행계획 통계 정보 갱신
쿼리 실행계획기, 실행계획 통계 정보 갱신
트랜잭션, 트랜잭션
트랜잭션 ID, 트랜잭션 ID 겹침 오류 방지
겹침, 트랜잭션 ID 겹침 오류 방지
트랜잭션 격리, 트랜잭션 격리
트랜잭션 격리 수준, 트랜잭션 격리
커밋된 읽기, 커밋된 읽기 격리 수준
트랜잭션 로그 (살펴볼 내용 WAL)
특정시점 복구, 백업과 복원
패스워드, role 속성
슈퍼유저의, 데이터베이스 클러스터 생성
인증, 패스워드 인증
피어, 피어(peer) 인증
함수, 사용자 정의 함수, 쿼리 언어 (SQL) 함수
RETURNS TABLE, SQL 함수에서 테이블 반환하기
SETOF 사용, SQL 함수에서 집합 반환하기
variadic, SQL 함수에서 여러 인자를 입력하기
사용자 정의, 사용자 정의 함수, 쿼리 언어 (SQL) 함수
SQL 기반, 쿼리 언어 (SQL) 함수
이름 기반 인자, SQL 함수 인자
인자 기본값, SQL 함수의 인자 기본값 지정
출력 매개 변수, SQL 함수에서 출력 매개 변수 사용하기
환경 설정
서버, 서버 환경 설정
휘발성, 휘발성에 따른 함수 분류
함수, 휘발성에 따른 함수 분류

A

abbrev, Network Address Functions and Operators
ABORT, ABORT
abs, Mathematical Functions and Operators
ACL, Privileges
aclcontains, System Information Functions and Operators
acldefault, System Information Functions and Operators
aclexplode, System Information Functions and Operators
aclitem, Privileges
aclitemeq, System Information Functions and Operators
acos, Mathematical Functions and Operators
acosd, Mathematical Functions and Operators
acosh, Mathematical Functions and Operators
administration tools
externally maintained, Administration Tools
adminpack, adminpack
advisory lock, Advisory Locks
age, Date/Time Functions and Operators
aggregate function, 집계 함수, Aggregate Expressions, Aggregate Functions
built-in, Aggregate Functions
invocation, Aggregate Expressions
AIX, AIX
installation on, AIX
IPC configuration, 공유 메모리 및 세마포어
akeys, hstore Operators and Functions
alias, Table and Column Aliases, Column Labels
for table name in query, 테이블 조인
in the FROM clause, Table and Column Aliases
in the select list, Column Labels
ALL, Subquery Expressions, Row and Array Comparisons
allow_system_table_mods 환경 설정 매개 변수, 개발자 옵션
ALTER AGGREGATE, ALTER AGGREGATE
ALTER COLLATION, ALTER COLLATION
ALTER CONVERSION, ALTER CONVERSION
ALTER DATABASE, ALTER DATABASE
ALTER DEFAULT PRIVILEGES, ALTER DEFAULT PRIVILEGES
ALTER DOMAIN, ALTER DOMAIN
ALTER EVENT TRIGGER, ALTER EVENT TRIGGER
ALTER EXTENSION, ALTER EXTENSION
ALTER FOREIGN DATA WRAPPER, ALTER FOREIGN DATA WRAPPER
ALTER FOREIGN TABLE, ALTER FOREIGN TABLE
ALTER FUNCTION, ALTER FUNCTION
ALTER GROUP, ALTER GROUP
ALTER INDEX, ALTER INDEX
ALTER LANGUAGE, ALTER LANGUAGE
ALTER LARGE OBJECT, ALTER LARGE OBJECT
ALTER MATERIALIZED VIEW, ALTER MATERIALIZED VIEW
ALTER OPERATOR, ALTER OPERATOR
ALTER OPERATOR CLASS, ALTER OPERATOR CLASS
ALTER OPERATOR FAMILY, ALTER OPERATOR FAMILY
ALTER POLICY, ALTER POLICY
ALTER PROCEDURE, ALTER PROCEDURE
ALTER PUBLICATION, ALTER PUBLICATION
ALTER ROLE, role 속성, ALTER ROLE
ALTER ROUTINE, ALTER ROUTINE
ALTER RULE, ALTER RULE
ALTER SCHEMA, ALTER SCHEMA
ALTER SEQUENCE, ALTER SEQUENCE
ALTER SERVER, ALTER SERVER
ALTER STATISTICS, ALTER STATISTICS
ALTER SUBSCRIPTION, ALTER SUBSCRIPTION
ALTER SYSTEM, ALTER SYSTEM
ALTER TABLE, ALTER TABLE
ALTER TABLESPACE, ALTER TABLESPACE
ALTER TEXT SEARCH CONFIGURATION, ALTER TEXT SEARCH CONFIGURATION
ALTER TEXT SEARCH DICTIONARY, ALTER TEXT SEARCH DICTIONARY
ALTER TEXT SEARCH PARSER, ALTER TEXT SEARCH PARSER
ALTER TEXT SEARCH TEMPLATE, ALTER TEXT SEARCH TEMPLATE
ALTER TRIGGER, ALTER TRIGGER
ALTER TYPE, ALTER TYPE
ALTER USER, ALTER USER
ALTER USER MAPPING, ALTER USER MAPPING
ALTER VIEW, ALTER VIEW
amcheck, amcheck
ANALYZE, 실행계획 통계 정보 갱신, ANALYZE
AND (operator), Logical Operators
any, Pseudo-Types
ANY, Aggregate Functions, Subquery Expressions, Row and Array Comparisons
anyarray, Pseudo-Types
anycompatible, Pseudo-Types
anycompatiblearray, Pseudo-Types
anycompatiblenonarray, Pseudo-Types
anycompatiblerange, Pseudo-Types
anyelement, Pseudo-Types
anyenum, Pseudo-Types
anynonarray, Pseudo-Types
anyrange, Pseudo-Types
applicable role, applicable_roles
application_name 환경 설정 매개 변수, What To 로그
arbitrary precision numbers, Arbitrary Precision Numbers
archive_cleanup_command configuration parameter, Archive Recovery
archive_command 환경 설정 매개 변수, 아카이브
archive_mode 환경 설정 매개 변수, 아카이브
archive_timeout 환경 설정 매개 변수, 아카이브
area, Geometric Functions and Operators
armor, armor(), dearmor()
array, 배열
accessing, 배열 접근
constant, 배열값 저장
constructor, Array Constructors
declaration, 배열 타입 정의
I/O, Array Input and Output Syntax
modifying, 배열 수정
of user-defined type, User-Defined Types
searching, 배열 검색
ARRAY, Array Constructors, UNION, CASE, and Related Constructs
determination of result type, UNION, CASE, and Related Constructs
array_agg, Aggregate Functions, Functions
array_append, Array Functions and Operators
array_cat, Array Functions and Operators
array_dims, Array Functions and Operators
array_fill, Array Functions and Operators
array_length, Array Functions and Operators
array_lower, Array Functions and Operators
array_ndims, Array Functions and Operators
array_nulls 환경 설정 매개 변수, 이전 PostgreSQL 버전
array_position, Array Functions and Operators
array_positions, Array Functions and Operators
array_prepend, Array Functions and Operators
array_remove, Array Functions and Operators
array_replace, Array Functions and Operators
array_to_json, Processing and Creating JSON Data
array_to_string, Array Functions and Operators
array_to_tsvector, Text Search Functions and Operators
array_upper, Array Functions and Operators
ascii, String Functions and Operators
asin, Mathematical Functions and Operators
asind, Mathematical Functions and Operators
asinh, Mathematical Functions and Operators
ASSERT
in PL/pgSQL, Checking Assertions
assertions
in PL/pgSQL, Checking Assertions
AT TIME ZONE, AT TIME ZONE
atan, Mathematical Functions and Operators
atan2, Mathematical Functions and Operators
atan2d, Mathematical Functions and Operators
atand, Mathematical Functions and Operators
atanh, Mathematical Functions and Operators
authentication_timeout 환경 설정 매개 변수, 인증
auth_delay, auth_delay
auth_delay.milliseconds 환경 설정 매개 변수, 환경 설정 매개 변수
auto-increment (살펴볼 내용 serial)
autocommit
bulk-loading data, Disable Autocommit
psql, Variables
autosummarize storage parameter, 인덱스 저장 매개 변수
autovacuum
일반 정보, Autovacuum 데몬
환경 설정 매개 변수, 자동 Vacuuming
autovacuum 환경 설정 매개 변수, 자동 Vacuuming
autovacuum_analyze_scale_factor
configuration parameter, 자동 Vacuuming
storage parameter, 스토리지 매개 변수
autovacuum_analyze_threshold
configuration parameter, 자동 Vacuuming
storage parameter, 스토리지 매개 변수
autovacuum_enabled storage parameter, 스토리지 매개 변수
autovacuum_freeze_max_age
configuration parameter, 자동 Vacuuming
storage parameter, 스토리지 매개 변수
autovacuum_freeze_min_age storage parameter, 스토리지 매개 변수
autovacuum_freeze_table_age storage parameter, 스토리지 매개 변수
autovacuum_max_workers 환경 설정 매개 변수, 자동 Vacuuming
autovacuum_multixact_freeze_max_age
configuration parameter, 자동 Vacuuming
storage parameter, 스토리지 매개 변수
autovacuum_multixact_freeze_min_age storage parameter, 스토리지 매개 변수
autovacuum_multixact_freeze_table_age storage parameter, 스토리지 매개 변수
autovacuum_naptime 환경 설정 매개 변수, 자동 Vacuuming
autovacuum_vacuum_cost_delay
configuration parameter, 자동 Vacuuming
storage parameter, 스토리지 매개 변수
autovacuum_vacuum_cost_limit
configuration parameter, 자동 Vacuuming
storage parameter, 스토리지 매개 변수
autovacuum_vacuum_insert_scale_factor
configuration parameter, 자동 Vacuuming
storage parameter, 스토리지 매개 변수
autovacuum_vacuum_insert_threshold
configuration parameter, 자동 Vacuuming
storage parameter, 스토리지 매개 변수
autovacuum_vacuum_scale_factor
configuration parameter, 자동 Vacuuming
storage parameter, 스토리지 매개 변수
autovacuum_vacuum_threshold
configuration parameter, 자동 Vacuuming
storage parameter, 스토리지 매개 변수
autovacuum_work_mem 환경 설정 매개 변수, 메모리
auto_explain, auto_explain
auto_explain.log_analyze configuration parameter, 환경 설정 매개 변수들
auto_explain.log_buffers configuration parameter, 환경 설정 매개 변수들
auto_explain.log_format configuration parameter, 환경 설정 매개 변수들
auto_explain.log_level configuration parameter, 환경 설정 매개 변수들
auto_explain.log_min_duration configuration parameter, 환경 설정 매개 변수들
auto_explain.log_nested_statements configuration parameter, 환경 설정 매개 변수들
auto_explain.log_settings configuration parameter, 환경 설정 매개 변수들
auto_explain.log_timing configuration parameter, 환경 설정 매개 변수들
auto_explain.log_verbose configuration parameter, 환경 설정 매개 변수들
auto_explain.log_wal configuration parameter, 환경 설정 매개 변수들
auto_explain.sample_rate configuration parameter, 환경 설정 매개 변수들
avals, hstore Operators and Functions
average, Aggregate Functions
avg, Aggregate Functions

B

B-tree (살펴볼 내용 index)
backend_flush_after configuration parameter, 비동기 동작
Background workers, Background Worker Processes
backslash escapes, String Constants with C-Style Escapes
backslash_quote 환경 설정 매개 변수, 이전 PostgreSQL 버전
backtrace_functions configuration parameter, 개발자 옵션
backup, Backup Control Functions
Backup Manifest, Backup Manifest Format
base type, The PostgreSQL Type System
base64 format, Binary String Functions and Operators
BASE_BACKUP, Streaming Replication Protocol
BEGIN, BEGIN
BETWEEN, Comparison Functions and Operators
BETWEEN SYMMETRIC, Comparison Functions and Operators
BGWORKER_BACKEND_​DATABASE_CONNECTION, Background Worker Processes
BGWORKER_SHMEM_ACCESS, Background Worker Processes
bgwriter_delay 환경 설정 매개 변수, Background Writer
bgwriter_flush_after configuration parameter, Background Writer
bgwriter_lru_maxpages 환경 설정 매개 변수, Background Writer
bgwriter_lru_multiplier 환경 설정 매개 변수, Background Writer
bigint, Numeric Constants, Integer Types
bigserial, Serial Types
binary data, Binary Data Types, Binary String Functions and Operators
functions, Binary String Functions and Operators
binary string
concatenation, Binary String Functions and Operators
converting to character string, Binary String Functions and Operators
length, Binary String Functions and Operators
bison, Requirements
bit string, Bit-String Constants, Bit String Types
constant, Bit-String Constants
data type, Bit String Types
length, Bit String Functions and Operators
bit strings, Bit String Functions and Operators
functions, Bit String Functions and Operators
bitmap scan, Combining Multiple Indexes, 플래너 방법 환경 설정
bit_and, Aggregate Functions
bit_length, String Functions and Operators, Binary String Functions and Operators, Bit String Functions and Operators
bit_or, Aggregate Functions
BLOB (살펴볼 내용 large object)
block_size 환경 설정 매개 변수, 프리셋 옵션
bloom, bloom
bonjour 환경 설정 매개 변수, 접속 설정
bonjour_name 환경 설정 매개 변수, 접속 설정
Boolean, Boolean Type
data type, Boolean Type
operators (살펴볼 내용 operators, logical)
bool_and, Aggregate Functions
bool_or, Aggregate Functions
bound_box, Geometric Functions and Operators
box, Geometric Functions and Operators
box (data type), Boxes
BRIN (살펴볼 내용 index)
brin_desummarize_range, Index Maintenance Functions
brin_metapage_info, BRIN Functions
brin_page_items, BRIN Functions
brin_page_type, BRIN Functions
brin_revmap_data, BRIN Functions
brin_summarize_new_values, Index Maintenance Functions
brin_summarize_range, Index Maintenance Functions
broadcast, Network Address Functions and Operators
BSD 인증, BSD 인증
btree_gin, btree_gin
btree_gist, btree_gist
btrim, String Functions and Operators, Binary String Functions and Operators
bt_index_check, Functions
bt_index_parent_check, Functions
bt_metap, B-Tree Functions
bt_page_items, B-Tree Functions
bt_page_stats, B-Tree Functions
buffering storage parameter, 인덱스 저장 매개 변수
bytea, Binary Data Types
bytea_output 환경 설정 매개 변수, 문 동작

C

C, libpq — C Library, ECPG — Embedded SQL in C
C++, Using C++ for Extensibility
CALL, CALL
canceling, Canceling Queries in Progress
SQL command, Canceling Queries in Progress
cardinality, Array Functions and Operators
CASCADE, Dependency Tracking
with DROP, Dependency Tracking
foreign key action, Foreign Keys
Cascading Replication, 고가용성, 부하 분산, 복제
CASE, Conditional Expressions, UNION, CASE, and Related Constructs
determination of result type, UNION, CASE, and Related Constructs
case sensitivity
of SQL commands, Identifiers and Key Words
cast, CREATE CAST
I/O 변환, CREATE CAST
cbrt, Mathematical Functions and Operators
ceil, Mathematical Functions and Operators
ceiling, Mathematical Functions and Operators
center, Geometric Functions and Operators
chained transactions, Transaction Management, 매개 변수, 매개 변수
in PL/pgSQL, Transaction Management
char, Character Types
character, Character Types
character set, 로케일(locale) 및 출력 양식, 프리셋 옵션
character string, String Constants, Character Types
concatenation, String Functions and Operators
constant, String Constants
converting to binary string, Binary String Functions and Operators
data types, Character Types
length, String Functions and Operators
character varying, Character Types
character_length, String Functions and Operators
char_length, String Functions and Operators
check constraint, Check Constraints
CHECK OPTION, CREATE VIEW
checkpoint, WAL 환경 설정
CHECKPOINT, CHECKPOINT
checkpoint_completion_target 환경 설정 매개 변수, 체크포인트
checkpoint_flush_after configuration parameter, 체크포인트
checkpoint_timeout 환경 설정 매개 변수, 체크포인트
checkpoint_warning 환경 설정 매개 변수, 체크포인트
check_function_bodies 환경 설정 매개 변수, 문 동작
chr, String Functions and Operators
cid, Object Identifier Types
cidr, cidr
circle, Circles, Geometric Functions and Operators
citext, citext
client_encoding 환경 설정 매개 변수, 로케일(locale) 및 출력 양식
client_min_messages 환경 설정 매개 변수, 문 동작
clock_timestamp, Date/Time Functions and Operators
CLOSE, CLOSE
cluster
of databases (살펴볼 내용 database cluster)
CLUSTER, CLUSTER
clusterdb, clusterdb
clustering, 고가용성, 부하 분산, 복제
cluster_name 환경 설정 매개 변수, 프로세스 제목
cmax, System Columns
cmin, System Columns
COALESCE, COALESCE
COLLATE, Collation Expressions
collation
in PL/pgSQL, Collation of PL/pgSQL Variables
SQL 함수, 자국어 정렬과 관계된 SQL 함수
COLLATION FOR, System Information Functions and Operators
color, Color Support
column, 개념, Table Basics
adding, Adding a Column
removing, Removing a Column
renaming, Renaming a Column
system column, System Columns
column data type
changing, Changing a Column's Data Type
column reference, Column References
col_description, System Information Functions and Operators
comment, Comments
about database objects, System Information Functions and Operators
in SQL, Comments
COMMENT, COMMENT
COMMIT, COMMIT
COMMIT PREPARED, COMMIT PREPARED
commit_delay 환경 설정 매개 변수, 설정
commit_siblings 환경 설정 매개 변수, 설정
common table expression (살펴볼 내용 WITH)
comparison, Comparison Functions and Operators, Subquery Expressions
composite type, Row and Array Comparisons
operators, Comparison Functions and Operators
row constructor, Row and Array Comparisons
subquery result row, Subquery Expressions
compiling, Building libpq Programs
libpq applications, Building libpq Programs
composite type, Composite Types, The PostgreSQL Type System
comparison, Row and Array Comparisons
constant, Constructing Composite Values
constructor, Row Constructors
computed field, Using Composite Types in Queries
concat, String Functions and Operators
concat_ws, String Functions and Operators
concurrency, 동시성 제어
conditional expression, Conditional Expressions
configuration
of recovery
of a standby server, Archive Recovery
of the server
functions, Configuration Settings Functions
configure, Installation Procedure
configure environment variables, configure Environment Variables
configure options, configure Options
config_file 환경 설정 매개 변수, 파일 위치
conjunction, Logical Operators
connectby, Functions Provided, connectby
connection service file, The Connection Service File
conninfo, Connection Strings
constant, Constants
constraint, Constraints
adding, Adding a Constraint
check, Check Constraints
exclusion, Exclusion Constraints
foreign key, Foreign Keys
name, Check Constraints
NOT NULL, Not-Null Constraints
primary key, Primary Keys
removing, Removing a Constraint
unique, Unique Constraints
constraint exclusion, Partitioning and Constraint Exclusion, 실행 계획기 관련 기타 옵션들
constraint_exclusion 환경 설정 매개 변수, 실행 계획기 관련 기타 옵션들
container type, The PostgreSQL Type System
CONTINUE
in PL/pgSQL, CONTINUE
Continuous Archiving, 백업과 복원
control file, Extension Files
convert, Binary String Functions and Operators
convert_from, Binary String Functions and Operators
convert_to, Binary String Functions and Operators
COPY, 테이블에 자료 입력하기, Functions Associated with the COPY Command, COPY
with libpq, Functions Associated with the COPY Command
corr, Aggregate Functions
correlation, Aggregate Functions
in the query planner, Extended Statistics
cos, Mathematical Functions and Operators
cosd, Mathematical Functions and Operators
cosh, Mathematical Functions and Operators
cot, Mathematical Functions and Operators
cotd, Mathematical Functions and Operators
count, Aggregate Functions
covariance
population, Aggregate Functions
sample, Aggregate Functions
covar_pop, Aggregate Functions
covar_samp, Aggregate Functions
covering index, Index-Only Scans and Covering Indexes
cpu_index_tuple_cost 환경 설정 매개 변수, 플래너 비용 상수
cpu_operator_cost 환경 설정 매개 변수, 플래너 비용 상수
cpu_tuple_cost 환경 설정 매개 변수, 플래너 비용 상수
CREATE ACCESS METHOD, CREATE ACCESS METHOD
CREATE AGGREGATE, CREATE AGGREGATE
CREATE CAST, CREATE CAST
CREATE COLLATION, CREATE COLLATION
CREATE CONVERSION, CREATE CONVERSION
CREATE DATABASE, 데이터베이스 생성, CREATE DATABASE
CREATE DOMAIN, CREATE DOMAIN
CREATE EVENT TRIGGER, CREATE EVENT TRIGGER
CREATE EXTENSION, CREATE EXTENSION
CREATE FOREIGN DATA WRAPPER, CREATE FOREIGN DATA WRAPPER
CREATE FOREIGN TABLE, CREATE FOREIGN TABLE
CREATE FUNCTION, CREATE FUNCTION
CREATE GROUP, CREATE GROUP
CREATE INDEX, CREATE INDEX
CREATE LANGUAGE, CREATE LANGUAGE
CREATE MATERIALIZED VIEW, CREATE MATERIALIZED VIEW
CREATE OPERATOR, CREATE OPERATOR
CREATE OPERATOR CLASS, CREATE OPERATOR CLASS
CREATE OPERATOR FAMILY, CREATE OPERATOR FAMILY
CREATE POLICY, CREATE POLICY
CREATE PROCEDURE, CREATE PROCEDURE
CREATE PUBLICATION, CREATE PUBLICATION
CREATE ROLE, 데이터베이스 role, CREATE ROLE
CREATE RULE, CREATE RULE
CREATE SCHEMA, CREATE SCHEMA
CREATE SEQUENCE, CREATE SEQUENCE
CREATE SERVER, CREATE SERVER
CREATE STATISTICS, CREATE STATISTICS
CREATE SUBSCRIPTION, CREATE SUBSCRIPTION
CREATE TABLE, 새 테이블 만들기, CREATE TABLE
CREATE TABLE AS, CREATE TABLE AS
CREATE TABLESPACE, Tablespaces, CREATE TABLESPACE
CREATE TEXT SEARCH CONFIGURATION, CREATE TEXT SEARCH CONFIGURATION
CREATE TEXT SEARCH DICTIONARY, CREATE TEXT SEARCH DICTIONARY
CREATE TEXT SEARCH PARSER, CREATE TEXT SEARCH PARSER
CREATE TEXT SEARCH TEMPLATE, CREATE TEXT SEARCH TEMPLATE
CREATE TRANSFORM, CREATE TRANSFORM
CREATE TRIGGER, CREATE TRIGGER
CREATE TYPE, CREATE TYPE
CREATE USER, CREATE USER
CREATE USER MAPPING, CREATE USER MAPPING
CREATE VIEW, CREATE VIEW
createdb, 데이터베이스 만들기, 데이터베이스 생성, createdb
createuser, 데이터베이스 role, createuser
CREATE_REPLICATION_SLOT, Streaming Replication Protocol
cross compilation, Build Process Details
cross join, Joined Tables
crosstab, crosstab(text), crosstabN(text), crosstab(text, text)
crypt, crypt()
cstring, Pseudo-Types
CSV (Comma-Separated Values) format
in psql, Meta-Commands
ctid, System Columns
CTID, View Rules in Non-SELECT Statements
CUBE, GROUPING SETS, CUBE, and ROLLUP
cube (extension), cube
cume_dist, Window Functions
hypothetical, Aggregate Functions
current_catalog, System Information Functions and Operators
current_database, System Information Functions and Operators
current_date, Date/Time Functions and Operators
current_logfiles
and the pg_current_logfile function, System Information Functions and Operators
log_destination 환경 설정 매개 변수, Where To 로그
current_query, System Information Functions and Operators
current_role, System Information Functions and Operators
current_schema, System Information Functions and Operators
current_schemas, System Information Functions and Operators
current_setting, Configuration Settings Functions
current_time, Date/Time Functions and Operators
current_timestamp, Date/Time Functions and Operators
current_user, System Information Functions and Operators
currval, Sequence Manipulation Functions
cursor, Cursors, CLOSE, DECLARE, EXPLAIN, FETCH, MOVE
CLOSE, CLOSE
DECLARE, DECLARE
FETCH, FETCH
in PL/pgSQL, Cursors
MOVE, MOVE
쿼리 실행 계획 보기, EXPLAIN
cursor_tuple_fraction 환경 설정 매개 변수, 실행 계획기 관련 기타 옵션들
custom scan provider, Writing a Custom Scan Provider
handler for, Writing a Custom Scan Provider
Cygwin, Cygwin
installation on, Cygwin

D

data partitioning, 고가용성, 부하 분산, 복제
data type, Data Types, Numeric Types, Enumerated Types, Domain Types, Type Conversion, The PostgreSQL Type System, The PostgreSQL Type System, The PostgreSQL Type System, Polymorphic Types, Base Types in C-Language Functions, User-Defined Types
base, The PostgreSQL Type System
category, Overview
composite, The PostgreSQL Type System
constant, Constants of Other Types
container, The PostgreSQL Type System
conversion, Type Conversion
domain, Domain Types
enumerated (enum), Enumerated Types
internal organization, Base Types in C-Language Functions
numeric, Numeric Types
polymorphic, Polymorphic Types
type cast, Type Casts
user-defined, User-Defined Types
database, 데이터베이스 만들기
creating, 데이터베이스 만들기
database activity, 데이터베이스 성능 모니터링
monitoring, 데이터베이스 성능 모니터링
database cluster, 개념
data_checksums 환경 설정 매개 변수, 프리셋 옵션
data_directory 환경 설정 매개 변수, 파일 위치
data_directory_mode configuration parameter, 프리셋 옵션
data_sync_retry configuration parameter, 에러 처리
date, Date/Time Types, Dates
constants, Special Values
current, Current Date/Time
output format, Date/Time Output
([살펴볼 다른 내용] formatting)
DateStyle 환경 설정 매개 변수, 로케일(locale) 및 출력 양식
date_part, Date/Time Functions and Operators, EXTRACT, date_part
date_trunc, Date/Time Functions and Operators, date_trunc
dblink, dblink, dblink
dblink_build_sql_delete, dblink_build_sql_delete
dblink_build_sql_insert, dblink_build_sql_insert
dblink_build_sql_update, dblink_build_sql_update
dblink_cancel_query, dblink_cancel_query
dblink_close, dblink_close
dblink_connect, dblink_connect
dblink_connect_u, dblink_connect_u
dblink_disconnect, dblink_disconnect
dblink_error_message, dblink_error_message
dblink_exec, dblink_exec
dblink_fetch, dblink_fetch
dblink_get_connections, dblink_get_connections
dblink_get_notify, dblink_get_notify
dblink_get_pkey, dblink_get_pkey
dblink_get_result, dblink_get_result
dblink_is_busy, dblink_is_busy
dblink_open, dblink_open
dblink_send_query, dblink_send_query
db_user_namespace configuration parameter, 인증
deadlock, Deadlocks
timeout during, 잠금(lock) 관리
deadlock_timeout 환경 설정 매개 변수, 잠금(lock) 관리
DEALLOCATE, DEALLOCATE
dearmor, armor(), dearmor()
debug_deadlocks 환경 설정 매개 변수, 개발자 옵션
debug_pretty_print 환경 설정 매개 변수, What To 로그
debug_print_parse 환경 설정 매개 변수, What To 로그
debug_print_plan 환경 설정 매개 변수, What To 로그
debug_print_rewritten 환경 설정 매개 변수, What To 로그
decimal (살펴볼 내용 numeric)
DECLARE, DECLARE
decode, Binary String Functions and Operators
decode_bytea
in PL/Perl, Utility Functions in PL/Perl
decrypt, 저수준 암복호화 함수
decrypt_iv, 저수준 암복호화 함수
deduplicate_items storage parameter, 인덱스 저장 매개 변수
default value, Default Values
changing, Changing a Column's Default Value
default_statistics_target 환경 설정 매개 변수, 실행 계획기 관련 기타 옵션들
default_tablespace 환경 설정 매개 변수, 문 동작
default_table_access_method configuration parameter, 문 동작
default_text_search_config 환경 설정 매개 변수, 로케일(locale) 및 출력 양식
default_transaction_deferrable 환경 설정 매개 변수, 문 동작
default_transaction_isolation 환경 설정 매개 변수, 문 동작
default_transaction_read_only 환경 설정 매개 변수, 문 동작
deferrable transaction
setting, SET TRANSACTION
setting default, 문 동작
defined, hstore Operators and Functions
degrees, Mathematical Functions and Operators
delay, Delaying Execution
DELETE, 자료 삭제, Deleting Data, Returning Data from Modified Rows, DELETE
RETURNING, Returning Data from Modified Rows
delete, hstore Operators and Functions
deleting, Deleting Data
dense_rank, Window Functions
hypothetical, Aggregate Functions
diagonal, Geometric Functions and Operators
diameter, Geometric Functions and Operators
dict_int, dict_int
dict_xsyn, dict_xsyn
difference, Soundex
digest, digest()
dirty read, 트랜잭션 격리
DISCARD, DISCARD
disjunction, Logical Operators
disk drive, WAL 인터널
DISTINCT, 테이블에 있는 자료 조회하기, DISTINCT
div, Mathematical Functions and Operators
dmetaphone, Double Metaphone
dmetaphone_alt, Double Metaphone
DO, DO
document, What Is a Document?
text search, What Is a Document?
dollar quoting, Dollar-Quoted String Constants
domain, Domain Types
double precision, Floating-Point Types
DROP ACCESS METHOD, DROP ACCESS METHOD
DROP AGGREGATE, DROP AGGREGATE
DROP CAST, DROP CAST
DROP COLLATION, DROP COLLATION
DROP CONVERSION, DROP CONVERSION
DROP DATABASE, 데이터베이스 소멸, DROP DATABASE
DROP DOMAIN, DROP DOMAIN
DROP EVENT TRIGGER, DROP EVENT TRIGGER
DROP EXTENSION, DROP EXTENSION
DROP FOREIGN DATA WRAPPER, DROP FOREIGN DATA WRAPPER
DROP FOREIGN TABLE, DROP FOREIGN TABLE
DROP FUNCTION, DROP FUNCTION
DROP GROUP, DROP GROUP
DROP INDEX, DROP INDEX
DROP LANGUAGE, DROP LANGUAGE
DROP MATERIALIZED VIEW, DROP MATERIALIZED VIEW
DROP OPERATOR, DROP OPERATOR
DROP OPERATOR CLASS, DROP OPERATOR CLASS
DROP OPERATOR FAMILY, DROP OPERATOR FAMILY
DROP OWNED, DROP OWNED
DROP POLICY, DROP POLICY
DROP PROCEDURE, DROP PROCEDURE
DROP PUBLICATION, DROP PUBLICATION
DROP ROLE, 데이터베이스 role, DROP ROLE
DROP ROUTINE, DROP ROUTINE
DROP RULE, DROP RULE
DROP SCHEMA, DROP SCHEMA
DROP SEQUENCE, DROP SEQUENCE
DROP SERVER, DROP SERVER
DROP STATISTICS, DROP STATISTICS
DROP SUBSCRIPTION, DROP SUBSCRIPTION
DROP TABLE, 새 테이블 만들기, DROP TABLE
DROP TABLESPACE, DROP TABLESPACE
DROP TEXT SEARCH CONFIGURATION, DROP TEXT SEARCH CONFIGURATION
DROP TEXT SEARCH DICTIONARY, DROP TEXT SEARCH DICTIONARY
DROP TEXT SEARCH PARSER, DROP TEXT SEARCH PARSER
DROP TEXT SEARCH TEMPLATE, DROP TEXT SEARCH TEMPLATE
DROP TRANSFORM, DROP TRANSFORM
DROP TRIGGER, DROP TRIGGER
DROP TYPE, DROP TYPE
DROP USER, DROP USER
DROP USER MAPPING, DROP USER MAPPING
DROP VIEW, DROP VIEW
dropdb, 데이터베이스 소멸, dropdb
dropuser, 데이터베이스 role, dropuser
DROP_REPLICATION_SLOT, Streaming Replication Protocol
DTD, Creating XML Values
DTrace, Developer Options, Dynamic Tracing
duplicate, 테이블에 있는 자료 조회하기
duplicates, DISTINCT
dynamic loading, 그 외 기본값, Dynamic Loading
dynamic_library_path, Dynamic Loading
dynamic_library_path 환경 설정 매개 변수, 그 외 기본값
dynamic_shared_memory_type 환경 설정 매개 변수, 메모리

E

each, hstore Operators and Functions
earth, Cube-Based Earth Distances
earthdistance, earthdistance
earth_box, Cube-Based Earth Distances
earth_distance, Cube-Based Earth Distances
ECPG, ECPG — Embedded SQL in C
ecpg, ecpg
effective_cache_size 환경 설정 매개 변수, 플래너 비용 상수
effective_io_concurrency 환경 설정 매개 변수, 비동기 동작
elog, Reporting Errors Within the Server
in PL/Perl, Utility Functions in PL/Perl
in PL/Python, Utility Functions
in PL/Tcl, Database Access from PL/Tcl
embedded SQL, ECPG — Embedded SQL in C
in C, ECPG — Embedded SQL in C
enabled role, enabled_roles
enable_bitmapscan 환경 설정 매개 변수, 플래너 방법 환경 설정
enable_gathermerge configuration parameter, 플래너 방법 환경 설정
enable_hashagg 환경 설정 매개 변수, 플래너 방법 환경 설정
enable_hashjoin 환경 설정 매개 변수, 플래너 방법 환경 설정
enable_incremental_sort configuration parameter, 플래너 방법 환경 설정
enable_indexonlyscan 환경 설정 매개 변수, 플래너 방법 환경 설정
enable_indexscan 환경 설정 매개 변수, 플래너 방법 환경 설정
enable_material 환경 설정 매개 변수, 플래너 방법 환경 설정
enable_mergejoin 환경 설정 매개 변수, 플래너 방법 환경 설정
enable_nestloop 환경 설정 매개 변수, 플래너 방법 환경 설정
enable_parallel_append configuration parameter, 플래너 방법 환경 설정
enable_parallel_hash configuration parameter, 플래너 방법 환경 설정
enable_partitionwise_aggregate configuration parameter, 플래너 방법 환경 설정
enable_partitionwise_join 환경 설정 매개 변수, 플래너 방법 환경 설정
enable_partition_pruning configuration parameter, 플래너 방법 환경 설정
enable_seqscan 환경 설정 매개 변수, 플래너 방법 환경 설정
enable_sort 환경 설정 매개 변수, 플래너 방법 환경 설정
enable_tidscan 환경 설정 매개 변수, 플래너 방법 환경 설정
encode, Binary String Functions and Operators
encode_array_constructor
in PL/Perl, Utility Functions in PL/Perl
encode_array_literal
in PL/Perl, Utility Functions in PL/Perl
encode_bytea
in PL/Perl, Utility Functions in PL/Perl
encode_typed_literal
in PL/Perl, Utility Functions in PL/Perl
encrypt, 저수준 암복호화 함수
encrypt_iv, 저수준 암복호화 함수
END, END
enumerated types, Enumerated Types
enum_first, Enum Support Functions
enum_last, Enum Support Functions
enum_range, Enum Support Functions
environment variable, Environment Variables
ephemeral named relation
registering with SPI, SPI_register_relation, SPI_register_trigger_data
unregistering from SPI, SPI_unregister_relation
ereport, Reporting Errors Within the Server
error codes, PostgreSQL에러 코드
libpq, Main Functions
list of, PostgreSQL에러 코드
error message, Connection Status Functions
escape format, Binary String Functions and Operators
escape string syntax, String Constants with C-Style Escapes
escape_string_warning 환경 설정 매개 변수, 이전 PostgreSQL 버전
escaping strings, Escaping Strings for Inclusion in SQL Commands
in libpq, Escaping Strings for Inclusion in SQL Commands
event trigger, Event Triggers, Writing Event Trigger Functions in C
in C, Writing Event Trigger Functions in C
in PL/Tcl, Event Trigger Functions in PL/Tcl
event_source 환경 설정 매개 변수, Where To 로그
event_trigger, Pseudo-Types
every, Aggregate Functions
EXCEPT, Combining Queries
exceptions
in PL/pgSQL, Trapping Errors
in PL/Tcl, Error Handling in PL/Tcl
exclusion constraint, Exclusion Constraints
EXECUTE, EXECUTE
exist, hstore Operators and Functions
EXISTS, Subquery Expressions
EXIT
in PL/pgSQL, EXIT
exit_on_error 환경 설정 매개 변수, 에러 처리
exp, Mathematical Functions and Operators
EXPLAIN, Using EXPLAIN, EXPLAIN
expression, Value Expressions
order of evaluation, Expression Evaluation Rules
syntax, Value Expressions
extending SQL, Extending SQL
extension, Packaging Related Objects into an Extension
externally maintained, Extensions
external_pid_file 환경 설정 매개 변수, 파일 위치
extract, Date/Time Functions and Operators, EXTRACT, date_part
extra_float_digits 환경 설정 매개 변수, 로케일(locale) 및 출력 양식

F

factorial, Mathematical Functions and Operators
failover, 고가용성, 부하 분산, 복제
false, Boolean Type
family, Network Address Functions and Operators
fast path, The Fast-Path Interface
fastupdate storage parameter, 인덱스 저장 매개 변수
fdw_handler, Pseudo-Types
FETCH, FETCH
field
computed, Using Composite Types in Queries
field selection, Field Selection
file system mount points, Use of Secondary File Systems
file_fdw, file_fdw
fillfactor storage parameter, 인덱스 저장 매개 변수, 스토리지 매개 변수
FILTER, Aggregate Expressions
first_value, Window Functions
flex, Requirements
float4 (살펴볼 내용 real)
float8 (살펴볼 내용 double precision)
floating point, Floating-Point Types
floating-point
display, 로케일(locale) 및 출력 양식
floor, Mathematical Functions and Operators
force_parallel_mode 환경 설정 매개 변수, 실행 계획기 관련 기타 옵션들
foreign data, Foreign Data
foreign data wrapper, Writing a Foreign Data Wrapper
handler for, Writing a Foreign Data Wrapper
foreign key, 참조키, Foreign Keys
self-referential, Foreign Keys
foreign table, Foreign Data
format, String Functions and Operators, format
use in PL/pgSQL, Executing Dynamic Commands
formatting, Data Type Formatting Functions
format_type, System Information Functions and Operators
Free Space Map, Free Space Map
FreeBSD
IPC configuration, 공유 메모리 및 세마포어
shared library, Compiling and Linking Dynamically-Loaded Functions
시작 스크립트, 데이터베이스 서버 시작
from_collapse_limit 환경 설정 매개 변수, 실행 계획기 관련 기타 옵션들
FSM (살펴볼 내용 Free Space Map)
fsm_page_contents, General Functions
fsync 환경 설정 매개 변수, 설정
full text search, Text Search Types, Text Search Types, Full Text Search
data types, Text Search Types
functions and operators, Text Search Types
full_page_writes 환경 설정 매개 변수, 설정
function, Table Functions, Functions and Operators, Statistics Information Functions, Functions, Polymorphic Types, Internal Functions, C-Language Functions
in the FROM clause, Table Functions
internal, Internal Functions
invocation, Function Calls
mixed notation, Using Mixed Notation
named notation, Using Named Notation
polymorphic, Polymorphic Types
positional notation, Using Positional Notation
statistics, Statistics Information Functions
type resolution in an invocation, Functions
user-defined, C-Language Functions
in C, C-Language Functions
functional dependency, The GROUP BY and HAVING Clauses
fuzzystrmatch, fuzzystrmatch

G

gcd, Mathematical Functions and Operators
gc_to_sec, Cube-Based Earth Distances
generated column, Generated Columns, 매개 변수, 매개 변수
in triggers, Overview of Trigger Behavior
generate_series, Set Returning Functions
generate_subscripts, Set Returning Functions
gen_random_bytes, 난수 생성 함수
gen_random_uuid, UUID Functions, 난수 생성 함수
gen_salt, gen_salt()
GEQO (살펴볼 내용 genetic query optimization)
geqo 환경 설정 매개 변수, 유전 쿼리 최적화
geqo_effort 환경 설정 매개 변수, 유전 쿼리 최적화
geqo_generations 환경 설정 매개 변수, 유전 쿼리 최적화
geqo_pool_size 환경 설정 매개 변수, 유전 쿼리 최적화
geqo_seed 환경 설정 매개 변수, 유전 쿼리 최적화
geqo_selection_bias 환경 설정 매개 변수, 유전 쿼리 최적화
geqo_threshold 환경 설정 매개 변수, 유전 쿼리 최적화
get_bit, Binary String Functions and Operators, Bit String Functions and Operators
get_byte, Binary String Functions and Operators
get_current_ts_config, Text Search Functions and Operators
get_raw_page, General Functions
GIN (살펴볼 내용 index)
gin_clean_pending_list, Index Maintenance Functions
gin_fuzzy_search_limit 환경 설정 매개 변수, 그 외 기본값
gin_leafpage_items, GIN Functions
gin_metapage_info, GIN Functions
gin_page_opaque_info, GIN Functions
gin_pending_list_limit
configuration parameter, 문 동작
storage parameter, 인덱스 저장 매개 변수
GiST (살펴볼 내용 index)
global data, Global Data in PL/Tcl
in PL/Python, Sharing Data
in PL/Tcl, Global Data in PL/Tcl
GRANT, Privileges, GRANT
GREATEST, GREATEST and LEAST, UNION, CASE, and Related Constructs
determination of result type, UNION, CASE, and Related Constructs
Gregorian calendar, History of Units
GROUP BY, 집계 함수, The GROUP BY and HAVING Clauses
grouping, The GROUP BY and HAVING Clauses
GROUPING, Aggregate Functions
GROUPING SETS, GROUPING SETS, CUBE, and ROLLUP
gssapi, Secure TCP/IP Connections with GSSAPI Encryption
GSSAPI, GSSAPI 인증
with libpq, Parameter Key Words
GUID, UUID Type

H

hash (살펴볼 내용 index)
hash_bitmap_info, Hash Functions
hash_mem_multiplier configuration parameter, 메모리
hash_metapage_info, Hash Functions
hash_page_items, Hash Functions
hash_page_stats, Hash Functions
hash_page_type, Hash Functions
has_any_column_privilege, System Information Functions and Operators
has_column_privilege, System Information Functions and Operators
has_database_privilege, System Information Functions and Operators
has_foreign_data_wrapper_privilege, System Information Functions and Operators
has_function_privilege, System Information Functions and Operators
has_language_privilege, System Information Functions and Operators
has_schema_privilege, System Information Functions and Operators
has_sequence_privilege, System Information Functions and Operators
has_server_privilege, System Information Functions and Operators
has_tablespace_privilege, System Information Functions and Operators
has_table_privilege, System Information Functions and Operators
has_type_privilege, System Information Functions and Operators
HAVING, 집계 함수, The GROUP BY and HAVING Clauses
hba_file 환경 설정 매개 변수, 파일 위치
heap_page_items, Heap Functions
heap_page_item_attrs, Heap Functions
heap_tuple_infomask_flags, Heap Functions
height, Geometric Functions and Operators
hex format, Binary String Functions and Operators
hierarchical database, 개념
high availability, 고가용성, 부하 분산, 복제
history, PostgreSQL 간추린 역사
of PostgreSQL, PostgreSQL 간추린 역사
hmac, hmac()
host, Network Address Functions and Operators
host name, Parameter Key Words
hostmask, Network Address Functions and Operators
Hot Standby, 고가용성, 부하 분산, 복제
hot_standby 환경 설정 매개 변수, 대기 서버
hot_standby_feedback 환경 설정 매개 변수, 대기 서버
HP-UX
IPC 설정, 공유 메모리 및 세마포어
shared library, Compiling and Linking Dynamically-Loaded Functions
hstore, hstore, hstore Operators and Functions
hstore_to_array, hstore Operators and Functions
hstore_to_json, hstore Operators and Functions
hstore_to_jsonb, hstore Operators and Functions
hstore_to_jsonb_loose, hstore Operators and Functions
hstore_to_json_loose, hstore Operators and Functions
hstore_to_matrix, hstore Operators and Functions
huge_pages 환경 설정 매개 변수, 메모리
hypothetical-set aggregate
built-in, Aggregate Functions

I

icount, intarray 함수와 연산자들
ICU, PostgreSQL Features, 콜레이션 관리, 매개 변수
ident, Ident 인증
identifier, Identifiers and Key Words
length, Identifiers and Key Words
syntax of, Identifiers and Key Words
IDENTIFY_SYSTEM, Streaming Replication Protocol
ident_file 환경 설정 매개 변수, 파일 위치
idle_in_transaction_session_timeout configuration parameter, 문 동작
idx, intarray 함수와 연산자들
IFNULL, COALESCE
ignore_checksum_failure 환경 설정 매개 변수, 개발자 옵션
ignore_invalid_pages configuration parameter, 개발자 옵션
ignore_system_indexes 환경 설정 매개 변수, 개발자 옵션
IMMUTABLE, 휘발성에 따른 함수 분류
IMPORT FOREIGN SCHEMA, IMPORT FOREIGN SCHEMA
IN, Subquery Expressions, Row and Array Comparisons
INCLUDE
in index definitions, Index-Only Scans and Covering Indexes
include
환경 설정 파일, 환경 설정 파일 내용 관리
include_dir
in configuration file, 환경 설정 파일 내용 관리
include_if_exists
in configuration file, 환경 설정 파일 내용 관리
index, Indexes, Multicolumn Indexes, Indexes and ORDER BY, Combining Multiple Indexes, Unique Indexes, Indexes on Expressions, Partial Indexes, Index-Only Scans and Covering Indexes, Index-Only Scans and Covering Indexes, Examining Index Usage, GIN and GiST Index Types, GIN and GiST Index Types, Locking and Indexes, Interfacing Extensions to Indexes, 테이블을 잠그지 않는 인덱스 만들기, Rebuilding Indexes Concurrently, Operators and Functions
and ORDER BY, Indexes and ORDER BY
B-tree, Index Types
B-Tree, B-Tree Indexes
BRIN, Index Types, BRIN Indexes
combining multiple indexes, Combining Multiple Indexes
covering, Index-Only Scans and Covering Indexes
examining usage, Examining Index Usage
on expressions, Indexes on Expressions
for user-defined data type, Interfacing Extensions to Indexes
GIN, Index Types, GIN and GiST Index Types, GIN Indexes
text search, GIN and GiST Index Types
GiST, Index Types, GIN and GiST Index Types, GiST Indexes
text search, GIN and GiST Index Types
hash, Index Types
index-only scans, Index-Only Scans and Covering Indexes
locks, Locking and Indexes
multicolumn, Multicolumn Indexes
partial, Partial Indexes
rebuilding concurrently, Rebuilding Indexes Concurrently
SP-GiST, Index Types, SP-GiST Indexes
unique, Unique Indexes
테이블을 잠그지 않고 만들기, 테이블을 잠그지 않는 인덱스 만들기
Index Access Method, Index Access Method Interface Definition
index scan, 플래너 방법 환경 설정
index-only scan, Index-Only Scans and Covering Indexes
indexam
Index Access Method, Index Access Method Interface Definition
index_am_handler, Pseudo-Types
inet (data type), inet
inet_client_addr, System Information Functions and Operators
inet_client_port, System Information Functions and Operators
inet_merge, Network Address Functions and Operators
inet_same_family, Network Address Functions and Operators
inet_server_addr, System Information Functions and Operators
inet_server_port, System Information Functions and Operators
information schema, The Information Schema
inheritance, 상속, Inheritance
initcap, String Functions and Operators
initdb, 데이터베이스 클러스터 생성, initdb
Initialization Fork, The Initialization Fork
input function, User-Defined Types
INSERT, 테이블에 자료 입력하기, Inserting Data, Returning Data from Modified Rows, INSERT
RETURNING, Returning Data from Modified Rows
inserting, Inserting Data
installation, Installation from Source Code
on Windows, Installation from Source Code on Windows
instr function, Appendix
int2 (살펴볼 내용 smallint)
int4 (살펴볼 내용 integer)
int8 (살펴볼 내용 bigint)
intagg, intagg
intarray, intarray
integer, Numeric Constants, Integer Types
integer_datetimes 환경 설정 매개 변수, 프리셋 옵션
interfaces
externally maintained, Client Interfaces
internal, Pseudo-Types
INTERSECT, Combining Queries
interval, Date/Time Types, Interval Input
output format, Interval Output
([살펴볼 다른 내용] formatting)
IntervalStyle 환경 설정 매개 변수, 로케일(locale) 및 출력 양식
intset, intarray 함수와 연산자들
int_array_aggregate, Functions
int_array_enum, Functions
inverse distribution, Aggregate Functions
in_range support functions, B-Tree Support Functions
IS DISTINCT FROM, Comparison Functions and Operators, Row and Array Comparisons
IS DOCUMENT, IS DOCUMENT
IS FALSE, Comparison Functions and Operators
IS NOT DISTINCT FROM, Comparison Functions and Operators, Row and Array Comparisons
IS NOT DOCUMENT, IS NOT DOCUMENT
IS NOT FALSE, Comparison Functions and Operators
IS NOT NULL, Comparison Functions and Operators
IS NOT TRUE, Comparison Functions and Operators
IS NOT UNKNOWN, Comparison Functions and Operators
IS NULL, Comparison Functions and Operators, 플랫폼 및 클라이언트 호환성
IS TRUE, Comparison Functions and Operators
IS UNKNOWN, Comparison Functions and Operators
isclosed, Geometric Functions and Operators
isempty, Range Functions and Operators
isfinite, Date/Time Functions and Operators
isn, isn
ISNULL, Comparison Functions and Operators
isn_weak, 함수와 연산자들
isopen, Geometric Functions and Operators
is_array_ref
in PL/Perl, Utility Functions in PL/Perl
is_valid, 함수와 연산자들

J

JIT, Just-in-Time Compilation (JIT)
jit configuration parameter, 실행 계획기 관련 기타 옵션들
jit_above_cost configuration parameter, 플래너 비용 상수
jit_debugging_support configuration parameter, 개발자 옵션
jit_dump_bitcode configuration parameter, 개발자 옵션
jit_expressions configuration parameter, 개발자 옵션
jit_inline_above_cost configuration parameter, 플래너 비용 상수
jit_optimize_above_cost configuration parameter, 플래너 비용 상수
jit_profiling_support configuration parameter, 개발자 옵션
jit_provider configuration parameter, 공유 라이브러리 사전 로드
jit_tuple_deforming configuration parameter, 개발자 옵션
join, 테이블 조인, Joined Tables, Controlling the Planner with Explicit JOIN Clauses
controlling the order, Controlling the Planner with Explicit JOIN Clauses
cross, Joined Tables
left, Joined Tables
natural, Joined Tables
outer, 테이블 조인, Joined Tables
right, Joined Tables
self, 테이블 조인
join_collapse_limit 환경 설정 매개 변수, 실행 계획기 관련 기타 옵션들
JSON, JSON Types, JSON Functions and Operators
functions and operators, JSON Functions and Operators
JSONB, JSON Types
jsonb
containment, jsonb Containment and Existence
existence, jsonb Containment and Existence
indexes on, jsonb Indexing
jsonb_agg, Aggregate Functions
jsonb_array_elements, Processing and Creating JSON Data
jsonb_array_elements_text, Processing and Creating JSON Data
jsonb_array_length, Processing and Creating JSON Data
jsonb_build_array, Processing and Creating JSON Data
jsonb_build_object, Processing and Creating JSON Data
jsonb_each, Processing and Creating JSON Data
jsonb_each_text, Processing and Creating JSON Data
jsonb_extract_path, Processing and Creating JSON Data
jsonb_extract_path_text, Processing and Creating JSON Data
jsonb_insert, Processing and Creating JSON Data
jsonb_object, Processing and Creating JSON Data
jsonb_object_agg, Aggregate Functions
jsonb_object_keys, Processing and Creating JSON Data
jsonb_path_exists, Processing and Creating JSON Data
jsonb_path_exists_tz, Processing and Creating JSON Data
jsonb_path_match, Processing and Creating JSON Data
jsonb_path_match_tz, Processing and Creating JSON Data
jsonb_path_query, Processing and Creating JSON Data
jsonb_path_query_array, Processing and Creating JSON Data
jsonb_path_query_array_tz, Processing and Creating JSON Data
jsonb_path_query_first, Processing and Creating JSON Data
jsonb_path_query_first_tz, Processing and Creating JSON Data
jsonb_path_query_tz, Processing and Creating JSON Data
jsonb_populate_record, Processing and Creating JSON Data
jsonb_populate_recordset, Processing and Creating JSON Data
jsonb_pretty, Processing and Creating JSON Data
jsonb_set, Processing and Creating JSON Data
jsonb_set_lax, Processing and Creating JSON Data
jsonb_strip_nulls, Processing and Creating JSON Data
jsonb_to_record, Processing and Creating JSON Data
jsonb_to_recordset, Processing and Creating JSON Data
jsonb_to_tsvector, Text Search Functions and Operators
jsonb_typeof, Processing and Creating JSON Data
jsonpath, jsonpath Type
json_agg, Aggregate Functions
json_array_elements, Processing and Creating JSON Data
json_array_elements_text, Processing and Creating JSON Data
json_array_length, Processing and Creating JSON Data
json_build_array, Processing and Creating JSON Data
json_build_object, Processing and Creating JSON Data
json_each, Processing and Creating JSON Data
json_each_text, Processing and Creating JSON Data
json_extract_path, Processing and Creating JSON Data
json_extract_path_text, Processing and Creating JSON Data
json_object, Processing and Creating JSON Data
json_object_agg, Aggregate Functions
json_object_keys, Processing and Creating JSON Data
json_populate_record, Processing and Creating JSON Data
json_populate_recordset, Processing and Creating JSON Data
json_strip_nulls, Processing and Creating JSON Data
json_to_record, Processing and Creating JSON Data
json_to_recordset, Processing and Creating JSON Data
json_to_tsvector, Text Search Functions and Operators
json_typeof, Processing and Creating JSON Data
Julian date, Julian Dates
Just-In-Time compilation (살펴볼 내용 JIT)
justify_days, Date/Time Functions and Operators
justify_hours, Date/Time Functions and Operators
justify_interval, Date/Time Functions and Operators

K

key word, Identifiers and Key Words
syntax of, Identifiers and Key Words
krb_caseins_users configuration parameter, 인증
krb_server_keyfile configuration parameter, 인증

L

label (살펴볼 내용 alias)
lag, Window Functions
language_handler, Pseudo-Types
large object, Large Objects
lastval, Sequence Manipulation Functions
last_value, Window Functions
LATERAL, LATERAL Subqueries
in the FROM clause, LATERAL Subqueries
latitude, Cube-Based Earth Distances
lca, Operators and Functions
lcm, Mathematical Functions and Operators
lc_collate 환경 설정 매개 변수, 프리셋 옵션
lc_ctype 환경 설정 매개 변수, 프리셋 옵션
lc_messages 환경 설정 매개 변수, 로케일(locale) 및 출력 양식
lc_monetary 환경 설정 매개 변수, 로케일(locale) 및 출력 양식
lc_numeric 환경 설정 매개 변수, 로케일(locale) 및 출력 양식
lc_time 환경 설정 매개 변수, 로케일(locale) 및 출력 양식
LDAP, PostgreSQL Features, LDAP 인증
LDAP connection parameter lookup, LDAP Lookup of Connection Parameters
ldconfig, Shared Libraries
lead, Window Functions
LEAST, GREATEST and LEAST, UNION, CASE, and Related Constructs
determination of result type, UNION, CASE, and Related Constructs
left, String Functions and Operators
left join, Joined Tables
length, String Functions and Operators, Binary String Functions and Operators, Bit String Functions and Operators, Geometric Functions and Operators, Text Search Functions and Operators
of a binary string (살펴볼 내용 binary strings, length)
of a character string (살펴볼 내용 character string, length)
length(tsvector), Manipulating Documents
levenshtein, Levenshtein
levenshtein_less_equal, Levenshtein
lex, Requirements
libedit, Requirements
libperl, Requirements
libpq, libpq — C Library, Retrieving Query Results Row-by-Row
single-row mode, Retrieving Query Results Row-by-Row
libpq-fe.h, libpq — C Library, Connection Status Functions
libpq-int.h, Connection Status Functions
libpython, Requirements
library finalization function, Dynamic Loading
library initialization function, Dynamic Loading
LIKE, LIKE
및 로케일, 동작
LIKE_REGEX, Differences from XQuery (LIKE_REGEX), SQL/JSON Regular Expressions
in SQL/JSON, SQL/JSON Regular Expressions
LIMIT, LIMIT and OFFSET
line, Lines, Geometric Functions and Operators
line segment, Line Segments
linear regression, Aggregate Functions
Linux
IPC 설정, 공유 메모리 및 세마포어
shared library, Compiling and Linking Dynamically-Loaded Functions
시작 스크립트, 데이터베이스 서버 시작
LISTEN, LISTEN
listen_addresses 환경 설정 매개 변수, 접속 설정
llvm-config, PostgreSQL Features
ll_to_earth, Cube-Based Earth Distances
ln, Mathematical Functions and Operators
lo, lo
LOAD, LOAD
load balancing, 고가용성, 부하 분산, 복제
locale, 데이터베이스 클러스터 생성
localtime, Date/Time Functions and Operators
localtimestamp, Date/Time Functions and Operators
local_preload_libraries 환경 설정 매개 변수, 공유 라이브러리 사전 로드
lock, Explicit Locking, Advisory Locks, Viewing Locks
advisory, Advisory Locks
monitoring, Viewing Locks
LOCK, Table-Level Locks, LOCK
lock_timeout 환경 설정 매개 변수, 문 동작
log, Mathematical Functions and Operators
log shipping, 고가용성, 부하 분산, 복제
log10, Mathematical Functions and Operators
Logging
current_logfiles file and the pg_current_logfile function, System Information Functions and Operators
pg_current_logfile function, System Information Functions and Operators
logging_collector 환경 설정 매개 변수, Where To 로그
logical_decoding_work_mem configuration parameter, 메모리
log_autovacuum_min_duration
configuration parameter, 자동 Vacuuming
storage parameter, 스토리지 매개 변수
log_btree_build_stats 환경 설정 매개 변수, 개발자 옵션
log_checkpoints 환경 설정 매개 변수, What To 로그
log_connections 환경 설정 매개 변수, What To 로그
log_destination 환경 설정 매개 변수, Where To 로그
log_directory 환경 설정 매개 변수, Where To 로그
log_disconnections 환경 설정 매개 변수, What To 로그
log_duration 환경 설정 매개 변수, What To 로그
log_error_verbosity 환경 설정 매개 변수, What To 로그
log_executor_stats 환경 설정 매개 변수, 통계 모니터링
log_filename 환경 설정 매개 변수, Where To 로그
log_file_mode 환경 설정 매개 변수, Where To 로그
log_hostname 환경 설정 매개 변수, What To 로그
log_line_prefix 환경 설정 매개 변수, What To 로그
log_lock_waits 환경 설정 매개 변수, What To 로그
log_min_duration_sample configuration parameter, When To 로그
log_min_duration_statement 환경 설정 매개 변수, When To 로그
log_min_error_statement 환경 설정 매개 변수, When To 로그
log_min_messages 환경 설정 매개 변수, When To 로그
log_parameter_max_length configuration parameter, What To 로그
log_parameter_max_length_on_error configuration parameter, What To 로그
log_parser_stats 환경 설정 매개 변수, 통계 모니터링
log_planner_stats 환경 설정 매개 변수, 통계 모니터링
log_replication_commands 환경 설정 매개 변수, What To 로그
log_rotation_age 환경 설정 매개 변수, Where To 로그
log_rotation_size 환경 설정 매개 변수, Where To 로그
log_statement 환경 설정 매개 변수, What To 로그
log_statement_sample_rate configuration parameter, When To 로그
log_statement_stats 환경 설정 매개 변수, 통계 모니터링
log_temp_files 환경 설정 매개 변수, What To 로그
log_timezone 환경 설정 매개 변수, What To 로그
log_transaction_sample_rate configuration parameter, When To 로그
log_truncate_on_rotation 환경 설정 매개 변수, Where To 로그
longitude, Cube-Based Earth Distances
looks_like_number
in PL/Perl, Utility Functions in PL/Perl
loop, Simple Loops
in PL/pgSQL, Simple Loops
lower, String Functions and Operators, Range Functions and Operators
및 로케일, 동작
lower_inc, Range Functions and Operators
lower_inf, Range Functions and Operators
lo_close, Closing a Large Object Descriptor
lo_compat_privileges 환경 설정 매개 변수, 이전 PostgreSQL 버전
lo_creat, Creating a Large Object, Server-Side Functions
lo_create, Creating a Large Object
lo_export, Exporting a Large Object, Server-Side Functions
lo_from_bytea, Server-Side Functions
lo_get, Server-Side Functions
lo_import, Importing a Large Object, Server-Side Functions
lo_import_with_oid, Importing a Large Object
lo_lseek, Seeking in a Large Object
lo_lseek64, Seeking in a Large Object
lo_open, Opening an Existing Large Object
lo_put, Server-Side Functions
lo_read, Reading Data from a Large Object
lo_tell, Obtaining the Seek Position of a Large Object
lo_tell64, Obtaining the Seek Position of a Large Object
lo_truncate, Truncating a Large Object
lo_truncate64, Truncating 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, Line Segments, Geometric Functions and Operators
LSN, WAL 인터널
ltree, ltree
ltree2text, Operators and Functions
ltrim, String Functions and Operators

M

MAC address (살펴볼 내용 macaddr)
MAC address (EUI-64 format) (살펴볼 내용 macaddr)
macaddr (data type), macaddr
macaddr8 (data type), macaddr8
macaddr8_set7bit, Network Address Functions and Operators
macOS, macOS
installation on, macOS
IPC 설정, 공유 메모리 및 세마포어
shared library, Compiling and Linking Dynamically-Loaded Functions
magic block, Dynamic Loading
maintenance_io_concurrency configuration parameter, 비동기 동작
maintenance_work_mem 환경 설정 매개 변수, 메모리
make, Requirements
makeaclitem, System Information Functions and Operators
make_date, Date/Time Functions and Operators
make_interval, Date/Time Functions and Operators
make_time, Date/Time Functions and Operators
make_timestamp, Date/Time Functions and Operators
make_timestamptz, Date/Time Functions and Operators
make_valid, 함수와 연산자들
MANPATH, Environment Variables
masklen, Network Address Functions and Operators
materialized view, Materialized Views
implementation through rules, Materialized Views
materialized views, pg_matviews
max, Aggregate Functions
max_connections 환경 설정 매개 변수, 접속 설정
max_files_per_process 환경 설정 매개 변수, 커널 리소스 사용량
max_function_args 환경 설정 매개 변수, 프리셋 옵션
max_identifier_length 환경 설정 매개 변수, 프리셋 옵션
max_index_keys 환경 설정 매개 변수, 프리셋 옵션
max_locks_per_transaction 환경 설정 매개 변수, 잠금(lock) 관리
max_logical_replication_workers configuration parameter, Subscribers
max_parallel_maintenance_workers configuration parameter, 비동기 동작
max_parallel_workers configuration parameter, 비동기 동작
max_parallel_workers_per_gather 환경 설정 매개 변수, 비동기 동작
max_pred_locks_per_page configuration parameter, 잠금(lock) 관리
max_pred_locks_per_relation configuration parameter, 잠금(lock) 관리
max_pred_locks_per_transaction 환경 설정 매개 변수, 잠금(lock) 관리
max_prepared_transactions 환경 설정 매개 변수, 메모리
max_replication_slots 환경 설정 매개 변수, 전송 서버들
max_slot_wal_keep_size configuration parameter, 전송 서버들
max_stack_depth 환경 설정 매개 변수, 메모리
max_standby_archive_delay 환경 설정 매개 변수, 대기 서버
max_standby_streaming_delay 환경 설정 매개 변수, 대기 서버
max_sync_workers_per_subscription configuration parameter, Subscribers
max_wal_senders 환경 설정 매개 변수, 전송 서버들
max_wal_size 환경 설정 매개 변수, 체크포인트
max_worker_processes 환경 설정 매개 변수, 비동기 동작
md5, String Functions and Operators, Binary String Functions and Operators
MD5, 패스워드 인증
median, Aggregate Expressions
([살펴볼 다른 내용] percentile)
memory context
in SPI, Memory Management
memory overcommit, Linux 메모리 Overcommit
metaphone, Metaphone
min, Aggregate Functions
MinGW, MinGW/Native Windows
installation on, MinGW/Native Windows
min_parallel_index_scan_size configuration parameter, 플래너 비용 상수
min_parallel_table_scan_size configuration parameter, 플래너 비용 상수
min_scale, Mathematical Functions and Operators
min_wal_size 환경 설정 매개 변수, 체크포인트
mod, Mathematical Functions and Operators
mode
statistical, Aggregate Functions
MOVE, MOVE
Multiversion Concurrency Control, 소개
MultiXactId, 다중 트랜잭션과 겹침
MVCC, 소개

N

name, Identifiers and Key Words
qualified, Creating a Schema
syntax of, Identifiers and Key Words
unqualified, The Schema Search Path
NaN (살펴볼 내용 not a number)
natural join, Joined Tables
negation, Logical Operators
NetBSD
IPC 설정, 공유 메모리 및 세마포어
shared library, Compiling and Linking Dynamically-Loaded Functions
시작 스크립트, 데이터베이스 서버 시작
netmask, Network Address Functions and Operators
network, Network Address Types, Network Address Functions and Operators
data types, Network Address Types
nextval, Sequence Manipulation Functions
NFS, NFS
nlevel, Operators and Functions
non-durable, Non-Durable Settings
nonblocking connection, Database Connection Control Functions, Asynchronous Command Processing
nonrepeatable read, 트랜잭션 격리
normalize, String Functions and Operators
normalized, String Functions and Operators
normal_rand, normal_rand
NOT (operator), Logical Operators
not a number
double precision, Floating-Point Types
numeric (data type), Arbitrary Precision Numbers
NOT IN, Subquery Expressions, Row and Array Comparisons
not-null constraint, Not-Null Constraints
notation, Calling Functions
functions, Calling Functions
notice processing, Notice Processing
in libpq, Notice Processing
notice processor, Notice Processing
notice receiver, Notice Processing
NOTIFY, Asynchronous Notification, NOTIFY
in libpq, Asynchronous Notification
NOTNULL, Comparison Functions and Operators
now, Date/Time Functions and Operators
npoints, Geometric Functions and Operators
nth_value, Window Functions
ntile, Window Functions
null value
with check constraints, Check Constraints
comparing, Comparison Functions and Operators
default value, Default Values
in DISTINCT, DISTINCT
in libpq, Retrieving Query Result Information
in PL/Perl, PL/Perl Functions and Arguments
in PL/Python, Null, None
with unique constraints, Unique Constraints
NULLIF, NULLIF
number
constant, Numeric Constants
numeric, Numeric Constants
numeric (data type), Arbitrary Precision Numbers
numnode, Text Search Functions and Operators, Manipulating Queries
num_nonnulls, Comparison Functions and Operators
num_nulls, Comparison Functions and Operators
NVL, COALESCE

O

object identifier, Object Identifier Types
data type, Object Identifier Types
object-oriented database, 개념
obj_description, System Information Functions and Operators
octet_length, String Functions and Operators, Binary String Functions and Operators, Bit String Functions and Operators
OFFSET, LIMIT and OFFSET
oid, Object Identifier Types
OID
in libpq, Retrieving Other Result Information
oid2name, oid2name
old_snapshot_threshold configuration parameter, 비동기 동작
ON CONFLICT, INSERT
ONLY, The FROM Clause
OOM, Linux 메모리 Overcommit
OpenBSD
IPC 설정, 공유 메모리 및 세마포어
shared library, Compiling and Linking Dynamically-Loaded Functions
시작 스크립트, 데이터베이스 서버 시작
OpenSSL, PostgreSQL Features
([살펴볼 다른 내용] SSL)
operator, Operators, Operator Precedence, Functions and Operators, Logical Operators, Operators
invocation, Operator Invocations
logical, Logical Operators
precedence, Operator Precedence
syntax, Operators
type resolution in an invocation, Operators
operator class, Operator Classes and Operator Families, Index Methods and Operator Classes
operator family, Operator Classes and Operator Families, Operator Classes and Operator Families
operator_precedence_warning 환경 설정 매개 변수, 이전 PostgreSQL 버전
optimization information, Function Optimization Information, 연산자 최적화 정보
for functions, Function Optimization Information
for operators, 연산자 최적화 정보
OR (operator), Logical Operators
Oracle, Porting from Oracle PL/SQL
porting from PL/SQL to PL/pgSQL, Porting from Oracle PL/SQL
ORDER BY, 테이블에 있는 자료 조회하기, Sorting Rows
및 로케일, 동작
ordered-set aggregate, Aggregate Expressions
built-in, Aggregate Functions
ordering operator, System Dependencies on Operator Classes
ordinality, Set Returning Functions
outer join, Joined Tables
output function, User-Defined Types
OVER clause, Window Function Calls
overcommit, Linux 메모리 Overcommit
OVERLAPS, Date/Time Functions and Operators
overlay, String Functions and Operators, Binary String Functions and Operators, Bit String Functions and Operators
owner, Privileges

P

pageinspect, pageinspect
pages_per_range storage parameter, 인덱스 저장 매개 변수
page_checksum, General Functions
page_header, General Functions
palloc, Writing Code
PAM, PostgreSQL Features, PAM 인증
parallel_leader_participation configuration parameter , 실행 계획기 관련 기타 옵션들
parallel_setup_cost 환경 설정 매개 변수, 플래너 비용 상수
parallel_tuple_cost 환경 설정 매개 변수, 플래너 비용 상수
parallel_workers storage parameter, 스토리지 매개 변수
parameter
syntax, Positional Parameters
parenthesis, Value Expressions
parse_ident, String Functions and Operators
partition pruning, Partition Pruning
partitioned table, Table Partitioning
partitioning, Table Partitioning
password file, The Password File
passwordcheck, passwordcheck
password_encryption configuration parameter, 인증
path, Geometric Functions and Operators
for schemas, 문 동작
PATH, Environment Variables
path (data type), Paths
pattern matching, Pattern Matching
patterns
in psql and pg_dump, Patterns
pclose, Geometric Functions and Operators
percentile
continuous, Aggregate Functions
discrete, Aggregate Functions
percent_rank, Window Functions
hypothetical, Aggregate Functions
performance, Performance Tips
perl, Requirements
Perl, PL/Perl — Perl Procedural Language
permission (살펴볼 내용 privilege)
pfree, Writing Code
PGAPPNAME, Environment Variables
pgbench, pgbench
PGcancel, Canceling Queries in Progress
PGCHANNELBINDING, Environment Variables
PGCLIENTENCODING, Environment Variables
PGconn, Database Connection Control Functions
PGCONNECT_TIMEOUT, Environment Variables
pgcrypto, pgcrypto
PGDATA, 데이터베이스 클러스터 생성
PGDATABASE, Environment Variables
PGDATESTYLE, Environment Variables
PGEventProc, Event Callback Procedure
PGGEQO, Environment Variables
PGGSSENCMODE, Environment Variables
PGGSSLIB, 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
pgp_armor_headers, pgp_armor_headers
pgp_key_id, pgp_key_id()
pgp_pub_decrypt, pgp_pub_decrypt()
pgp_pub_decrypt_bytea, pgp_pub_decrypt()
pgp_pub_encrypt, pgp_pub_encrypt()
pgp_pub_encrypt_bytea, pgp_pub_encrypt()
pgp_sym_decrypt, pgp_sym_decrypt()
pgp_sym_decrypt_bytea, pgp_sym_decrypt()
pgp_sym_encrypt, pgp_sym_encrypt()
pgp_sym_encrypt_bytea, pgp_sym_encrypt()
PGREQUIREPEER, Environment Variables
PGREQUIRESSL, Environment Variables
PGresult, Main Functions
pgrowlocks, pgrowlocks, Overview
PGSERVICE, Environment Variables
PGSERVICEFILE, Environment Variables
PGSSLCERT, Environment Variables
PGSSLCOMPRESSION, Environment Variables
PGSSLCRL, Environment Variables
PGSSLKEY, Environment Variables
PGSSLMAXPROTOCOLVERSION, Environment Variables
PGSSLMINPROTOCOLVERSION, Environment Variables
PGSSLMODE, Environment Variables
PGSSLROOTCERT, Environment Variables
pgstatginindex, Functions
pgstathashindex, Functions
pgstatindex, Functions
pgstattuple, pgstattuple, Functions
pgstattuple_approx, Functions
PGSYSCONFDIR, Environment Variables
PGTARGETSESSIONATTRS, Environment Variables
PGTZ, Environment Variables
PGUSER, Environment Variables
pgxs, Extension Building Infrastructure
pg_advisory_lock, Advisory Lock Functions
pg_advisory_lock_shared, Advisory Lock Functions
pg_advisory_unlock, Advisory Lock Functions
pg_advisory_unlock_all, Advisory Lock Functions
pg_advisory_unlock_shared, Advisory Lock Functions
pg_advisory_xact_lock, Advisory Lock Functions
pg_advisory_xact_lock_shared, Advisory Lock Functions
pg_aggregate, pg_aggregate
pg_am, pg_am
pg_amop, pg_amop
pg_amproc, pg_amproc
pg_archivecleanup, pg_archivecleanup
pg_attrdef, pg_attrdef
pg_attribute, pg_attribute
pg_authid, pg_authid
pg_auth_members, pg_auth_members
pg_available_extensions, pg_available_extensions
pg_available_extension_versions, pg_available_extension_versions
pg_backend_pid, System Information Functions and Operators
pg_backup_start_time, Backup Control Functions
pg_basebackup, pg_basebackup
pg_blocking_pids, System Information Functions and Operators
pg_buffercache, pg_buffercache
pg_buffercache_pages, pg_buffercache
pg_cancel_backend, Server Signaling Functions
pg_cast, pg_cast
pg_checksums, pg_checksums
pg_class, pg_class
pg_client_encoding, String Functions and Operators
pg_collation, pg_collation
pg_collation_actual_version, Database Object Management Functions
pg_collation_is_visible, System Information Functions and Operators
PG_COLOR, When Color is Used
PG_COLORS, Configuring the Colors
pg_column_size, Database Object Management Functions
pg_config, pg_config, pg_config
with ecpg, Processing Embedded SQL Programs
with libpq, Building libpq Programs
with user-defined C functions, Writing Code
pg_conf_load_time, System Information Functions and Operators
pg_constraint, pg_constraint
pg_controldata, pg_controldata
pg_control_checkpoint, System Information Functions and Operators
pg_control_init, System Information Functions and Operators
pg_control_recovery, System Information Functions and Operators
pg_control_system, System Information Functions and Operators
pg_conversion, pg_conversion
pg_conversion_is_visible, System Information Functions and Operators
pg_copy_logical_replication_slot, Replication Management Functions
pg_copy_physical_replication_slot, Replication Management Functions
pg_create_logical_replication_slot, Replication Management Functions
pg_create_physical_replication_slot, Replication Management Functions
pg_create_restore_point, Backup Control Functions
pg_ctl, 데이터베이스 클러스터 생성, 데이터베이스 서버 시작, pg_ctl
pg_current_logfile, System Information Functions and Operators
pg_current_snapshot, System Information Functions and Operators
pg_current_wal_flush_lsn, Backup Control Functions
pg_current_wal_insert_lsn, Backup Control Functions
pg_current_wal_lsn, Backup Control Functions
pg_current_xact_id, System Information Functions and Operators
pg_current_xact_id_if_assigned, System Information Functions and Operators
pg_cursors, pg_cursors
pg_database, 템플릿 데이터베이스, pg_database
pg_database_size, Database Object Management Functions
pg_db_role_setting, pg_db_role_setting
pg_ddl_command, Pseudo-Types
pg_default_acl, pg_default_acl
pg_depend, pg_depend
pg_describe_object, System Information Functions and Operators
pg_description, pg_description
pg_drop_replication_slot, Replication Management Functions
pg_dump, pg_dump
pg_dumpall, pg_dumpall
use during upgrade, pg_dumpall을 통한 데이터 업그레이드
pg_enum, pg_enum
pg_event_trigger, pg_event_trigger
pg_event_trigger_ddl_commands, Capturing Changes at Command End
pg_event_trigger_dropped_objects, Processing Objects Dropped by a DDL Command
pg_event_trigger_table_rewrite_oid, Handling a Table Rewrite Event
pg_event_trigger_table_rewrite_reason, Handling a Table Rewrite Event
pg_export_snapshot, Snapshot Synchronization Functions
pg_extension, pg_extension
pg_extension_config_dump, Extension Configuration Tables
pg_filenode_relation, Database Object Management Functions
pg_file_rename, adminpack
pg_file_settings, pg_file_settings
pg_file_sync, adminpack
pg_file_unlink, adminpack
pg_file_write, adminpack
pg_foreign_data_wrapper, pg_foreign_data_wrapper
pg_foreign_server, pg_foreign_server
pg_foreign_table, pg_foreign_table
pg_freespace, 함수들
pg_freespacemap, pg_freespacemap
pg_function_is_visible, System Information Functions and Operators
pg_get_constraintdef, System Information Functions and Operators
pg_get_expr, System Information Functions and Operators
pg_get_functiondef, System Information Functions and Operators
pg_get_function_arguments, System Information Functions and Operators
pg_get_function_identity_arguments, System Information Functions and Operators
pg_get_function_result, System Information Functions and Operators
pg_get_indexdef, System Information Functions and Operators
pg_get_keywords, System Information Functions and Operators
pg_get_object_address, System Information Functions and Operators
pg_get_ruledef, System Information Functions and Operators
pg_get_serial_sequence, System Information Functions and Operators
pg_get_statisticsobjdef, System Information Functions and Operators
pg_get_triggerdef, System Information Functions and Operators
pg_get_userbyid, System Information Functions and Operators
pg_get_viewdef, System Information Functions and Operators
pg_group, pg_group
pg_has_role, System Information Functions and Operators
pg_hba.conf, The pg_hba.conf 파일
pg_hba_file_rules, pg_hba_file_rules
pg_ident.conf, 사용자 이름 맵
pg_identify_object, System Information Functions and Operators
pg_identify_object_as_address, System Information Functions and Operators
pg_import_system_collations, Database Object Management Functions
pg_index, pg_index
pg_indexam_has_property, System Information Functions and Operators
pg_indexes, pg_indexes
pg_indexes_size, Database Object Management Functions
pg_index_column_has_property, System Information Functions and Operators
pg_index_has_property, System Information Functions and Operators
pg_inherits, pg_inherits
pg_init_privs, pg_init_privs
pg_isready, pg_isready
pg_is_in_backup, Backup Control Functions
pg_is_in_recovery, Recovery Control Functions
pg_is_other_temp_schema, System Information Functions and Operators
pg_is_wal_replay_paused, Recovery Control Functions
pg_jit_available, System Information Functions and Operators
pg_language, pg_language
pg_largeobject, pg_largeobject
pg_largeobject_metadata, pg_largeobject_metadata
pg_last_committed_xact, System Information Functions and Operators
pg_last_wal_receive_lsn, Recovery Control Functions
pg_last_wal_replay_lsn, Recovery Control Functions
pg_last_xact_replay_timestamp, Recovery Control Functions
pg_listening_channels, System Information Functions and Operators
pg_locks, pg_locks
pg_logdir_ls, adminpack
pg_logical_emit_message, Replication Management Functions
pg_logical_slot_get_binary_changes, Replication Management Functions
pg_logical_slot_get_changes, Replication Management Functions
pg_logical_slot_peek_binary_changes, Replication Management Functions
pg_logical_slot_peek_changes, Replication Management Functions
pg_lsn, pg_lsn Type
pg_ls_archive_statusdir, Generic File Access Functions
pg_ls_dir, Generic File Access Functions
pg_ls_logdir, Generic File Access Functions
pg_ls_tmpdir, Generic File Access Functions
pg_ls_waldir, Generic File Access Functions
pg_matviews, pg_matviews
pg_mcv_list_items, Inspecting MCV Lists
pg_my_temp_schema, System Information Functions and Operators
pg_namespace, pg_namespace
pg_notification_queue_usage, System Information Functions and Operators
pg_notify, pg_notify
pg_opclass, pg_opclass
pg_opclass_is_visible, System Information Functions and Operators
pg_operator, pg_operator
pg_operator_is_visible, System Information Functions and Operators
pg_opfamily, pg_opfamily
pg_opfamily_is_visible, System Information Functions and Operators
pg_options_to_table, System Information Functions and Operators
pg_partitioned_table, pg_partitioned_table
pg_partition_ancestors, Database Object Management Functions
pg_partition_root, Database Object Management Functions
pg_partition_tree, Database Object Management Functions
pg_policies, pg_policies
pg_policy, pg_policy
pg_postmaster_start_time, System Information Functions and Operators
pg_prepared_statements, pg_prepared_statements
pg_prepared_xacts, pg_prepared_xacts
pg_prewarm, pg_prewarm
pg_prewarm.autoprewarm configuration parameter, Configuration Parameters
pg_prewarm.autoprewarm_interval configuration parameter, Configuration Parameters
pg_proc, pg_proc
pg_promote, Recovery Control Functions
pg_publication, pg_publication
pg_publication_rel, pg_publication_rel
pg_publication_tables, pg_publication_tables
pg_range, pg_range
pg_read_binary_file, Generic File Access Functions
pg_read_file, Generic File Access Functions
pg_receivewal, pg_receivewal
pg_receivexlog, pg_receivexlog renamed to pg_receivewal (살펴볼 내용 pg_receivewal)
pg_recvlogical, pg_recvlogical
pg_relation_filenode, Database Object Management Functions
pg_relation_filepath, Database Object Management Functions
pg_relation_size, Database Object Management Functions
pg_reload_conf, Server Signaling Functions
pg_relpages, Functions
pg_replication_origin, pg_replication_origin
pg_replication_origin_advance, Replication Management Functions
pg_replication_origin_create, Replication Management Functions
pg_replication_origin_drop, Replication Management Functions
pg_replication_origin_oid, Replication Management Functions
pg_replication_origin_progress, Replication Management Functions
pg_replication_origin_session_is_setup, Replication Management Functions
pg_replication_origin_session_progress, Replication Management Functions
pg_replication_origin_session_reset, Replication Management Functions
pg_replication_origin_session_setup, Replication Management Functions
pg_replication_origin_status, pg_replication_origin_status
pg_replication_origin_xact_reset, Replication Management Functions
pg_replication_origin_xact_setup, Replication Management Functions
pg_replication_slots, pg_replication_slots
pg_replication_slot_advance, Replication Management Functions
pg_resetwal, pg_resetwal
pg_resetxlog, pg_resetxlog renamed to pg_resetwal (살펴볼 내용 pg_resetwal)
pg_restore, pg_restore
pg_rewind, pg_rewind
pg_rewrite, pg_rewrite
pg_roles, pg_roles
pg_rotate_logfile, Server Signaling Functions
pg_rules, pg_rules
pg_safe_snapshot_blocking_pids, System Information Functions and Operators
pg_seclabel, pg_seclabel
pg_seclabels, pg_seclabels
pg_sequence, pg_sequence
pg_sequences, pg_sequences
pg_service.conf, The Connection Service File
pg_settings, pg_settings
pg_shadow, pg_shadow
pg_shdepend, pg_shdepend
pg_shdescription, pg_shdescription
pg_shmem_allocations, pg_shmem_allocations
pg_shseclabel, pg_shseclabel
pg_size_bytes, Database Object Management Functions
pg_size_pretty, Database Object Management Functions
pg_sleep, Delaying Execution
pg_sleep_for, Delaying Execution
pg_sleep_until, Delaying Execution
pg_snapshot_xip, System Information Functions and Operators
pg_snapshot_xmax, System Information Functions and Operators
pg_snapshot_xmin, System Information Functions and Operators
pg_standby, pg_standby
pg_start_backup, Backup Control Functions
pg_statio_all_indexes, 통계 정보 보기, pg_statio_all_indexes
pg_statio_all_sequences, 통계 정보 보기, pg_statio_all_sequences
pg_statio_all_tables, 통계 정보 보기, pg_statio_all_tables
pg_statio_sys_indexes, 통계 정보 보기
pg_statio_sys_sequences, 통계 정보 보기
pg_statio_sys_tables, 통계 정보 보기
pg_statio_user_indexes, 통계 정보 보기
pg_statio_user_sequences, 통계 정보 보기
pg_statio_user_tables, 통계 정보 보기
pg_statistic, Single-Column Statistics, pg_statistic
pg_statistics_obj_is_visible, System Information Functions and Operators
pg_statistic_ext, Extended Statistics, pg_statistic_ext
pg_statistic_ext_data, Extended Statistics, pg_statistic_ext
pg_stats, Single-Column Statistics, pg_stats
pg_stats_ext, pg_stats_ext
pg_stat_activity, 통계 정보 보기, pg_stat_activity
pg_stat_all_indexes, 통계 정보 보기, pg_stat_all_indexes
pg_stat_all_tables, 통계 정보 보기, pg_stat_all_tables
pg_stat_archiver, 통계 정보 보기, pg_stat_archiver
pg_stat_bgwriter, 통계 정보 보기, pg_stat_bgwriter
pg_stat_clear_snapshot, Statistics Functions
pg_stat_database, 통계 정보 보기, pg_stat_database
pg_stat_database_conflicts, 통계 정보 보기, pg_stat_database_conflicts
pg_stat_file, Generic File Access Functions
pg_stat_get_activity, Statistics Functions
pg_stat_get_backend_activity, Statistics Functions
pg_stat_get_backend_activity_start, Statistics Functions
pg_stat_get_backend_client_addr, Statistics Functions
pg_stat_get_backend_client_port, Statistics Functions
pg_stat_get_backend_dbid, Statistics Functions
pg_stat_get_backend_idset, Statistics Functions
pg_stat_get_backend_pid, Statistics Functions
pg_stat_get_backend_start, Statistics Functions
pg_stat_get_backend_userid, Statistics Functions
pg_stat_get_backend_wait_event, Statistics Functions
pg_stat_get_backend_wait_event_type, Statistics Functions
pg_stat_get_backend_xact_start, Statistics Functions
pg_stat_get_snapshot_timestamp, Statistics Functions
pg_stat_gssapi, 통계 정보 보기, pg_stat_gssapi
pg_stat_progress_analyze, 통계 정보 보기
pg_stat_progress_basebackup, 통계 정보 보기
pg_stat_progress_cluster, 통계 정보 보기
pg_stat_progress_create_index, 통계 정보 보기
pg_stat_progress_vacuum, 통계 정보 보기
pg_stat_replication, 통계 정보 보기, pg_stat_replication
pg_stat_reset, Statistics Functions
pg_stat_reset_shared, Statistics Functions
pg_stat_reset_single_function_counters, Statistics Functions
pg_stat_reset_single_table_counters, Statistics Functions
pg_stat_reset_slru, Statistics Functions
pg_stat_slru, 통계 정보 보기, pg_stat_slru
pg_stat_ssl, 통계 정보 보기, pg_stat_ssl
pg_stat_statements, pg_stat_statements
function, 함수들
pg_stat_statements_reset, 함수들
pg_stat_subscription, 통계 정보 보기, pg_stat_subscription
pg_stat_sys_indexes, 통계 정보 보기
pg_stat_sys_tables, 통계 정보 보기
pg_stat_user_functions, 통계 정보 보기, pg_stat_user_functions
pg_stat_user_indexes, 통계 정보 보기
pg_stat_user_tables, 통계 정보 보기
pg_stat_wal_receiver, 통계 정보 보기, pg_stat_wal_receiver
pg_stat_xact_all_tables, 통계 정보 보기
pg_stat_xact_sys_tables, 통계 정보 보기
pg_stat_xact_user_functions, 통계 정보 보기
pg_stat_xact_user_tables, 통계 정보 보기
pg_stop_backup, Backup Control Functions
pg_subscription, pg_subscription
pg_subscription_rel, pg_subscription_rel
pg_switch_wal, Backup Control Functions
pg_tables, pg_tables
pg_tablespace, pg_tablespace
pg_tablespace_databases, System Information Functions and Operators
pg_tablespace_location, System Information Functions and Operators
pg_tablespace_size, Database Object Management Functions
pg_table_is_visible, System Information Functions and Operators
pg_table_size, Database Object Management Functions
pg_temp, 문 동작
함수 보안, SECURITY DEFINER 함수를 안전하게 만드는 방법
pg_terminate_backend, Server Signaling Functions
pg_test_fsync, pg_test_fsync
pg_test_timing, pg_test_timing
pg_timezone_abbrevs, pg_timezone_abbrevs
pg_timezone_names, pg_timezone_names
pg_total_relation_size, Database Object Management Functions
pg_transform, pg_transform
pg_trgm, pg_trgm
pg_trgm.similarity_threshold configuration parameter, GUC Parameters
pg_trgm.strict_word_similarity_threshold configuration parameter , GUC Parameters
pg_trgm.word_similarity_threshold configuration parameter , GUC Parameters
pg_trigger, pg_trigger
pg_trigger_depth, System Information Functions and Operators
pg_try_advisory_lock, Advisory Lock Functions
pg_try_advisory_lock_shared, Advisory Lock Functions
pg_try_advisory_xact_lock, Advisory Lock Functions
pg_try_advisory_xact_lock_shared, Advisory Lock Functions
pg_ts_config, pg_ts_config
pg_ts_config_is_visible, System Information Functions and Operators
pg_ts_config_map, pg_ts_config_map
pg_ts_dict, pg_ts_dict
pg_ts_dict_is_visible, System Information Functions and Operators
pg_ts_parser, pg_ts_parser
pg_ts_parser_is_visible, System Information Functions and Operators
pg_ts_template, pg_ts_template
pg_ts_template_is_visible, System Information Functions and Operators
pg_type, pg_type
pg_typeof, System Information Functions and Operators
pg_type_is_visible, System Information Functions and Operators
pg_upgrade, pg_upgrade
pg_user, pg_user
pg_user_mapping, pg_user_mapping
pg_user_mappings, pg_user_mappings
pg_verifybackup, pg_verifybackup
pg_views, pg_views
pg_visibility, pg_visibility
pg_visible_in_snapshot, System Information Functions and Operators
pg_waldump, pg_waldump
pg_walfile_name, Backup Control Functions
pg_walfile_name_offset, Backup Control Functions
pg_wal_lsn_diff, Backup Control Functions
pg_wal_replay_pause, Recovery Control Functions
pg_wal_replay_resume, Recovery Control Functions
pg_xact_commit_timestamp, System Information Functions and Operators
pg_xact_status, System Information Functions and Operators
pg_xlogdump, pg_xlogdump renamed to pg_waldump (살펴볼 내용 pg_waldump)
phantom read, 트랜잭션 격리
phraseto_tsquery, Text Search Functions and Operators, Parsing Queries
pi, Mathematical Functions and Operators
PIC, Compiling and Linking Dynamically-Loaded Functions
PID
determining PID of server process
in libpq, Connection Status Functions
PITR, 백업과 복원
PITR standby, 고가용성, 부하 분산, 복제
pkg-config, PostgreSQL Features
with ecpg, Processing Embedded SQL Programs
with libpq, Building libpq Programs
PL/Perl, PL/Perl — Perl Procedural Language
PL/PerlU, Trusted and Untrusted PL/Perl
PL/pgSQL, PL/pgSQL — SQL 프로시저 언어
PL/Python, PL/Python — Python Procedural Language
PL/SQL (Oracle), Porting from Oracle PL/SQL
porting to PL/pgSQL, Porting from Oracle PL/SQL
PL/Tcl, PL/Tcl — Tcl Procedural Language
plainto_tsquery, Text Search Functions and Operators, Parsing Queries
plan_cache_mode configuration parameter, 실행 계획기 관련 기타 옵션들
plperl.on_init configuration parameter, Configuration
plperl.on_plperlu_init configuration parameter, Configuration
plperl.on_plperl_init configuration parameter, Configuration
plperl.use_strict configuration parameter, Configuration
plpgsql.check_asserts configuration parameter, Checking Assertions
plpgsql.variable_conflict configuration parameter, Variable Substitution
pltcl.start_proc configuration parameter, PL/Tcl Configuration
pltclu.start_proc configuration parameter, PL/Tcl Configuration
point, Points, Geometric Functions and Operators
Point-in-Time Recovery, 백업과 복원
policy, Row Security Policies
polygon, Polygons, Geometric Functions and Operators
polymorphic function, Polymorphic Types
polymorphic type, Polymorphic Types
popen, Geometric Functions and Operators
populate_record, hstore Operators and Functions
port, Parameter Key Words
port 환경 설정 매개 변수, 접속 설정
position, String Functions and Operators, Binary String Functions and Operators, Bit String Functions and Operators
POSTGRES, 버클리 POSTGRES 프로젝트
postgres, 기본 구조, 데이터베이스 생성, postgres
postgres 사용자, PostgreSQL 사용자 계정
Postgres95, Postgres95
postgresql.auto.conf, 환경 설정 파일을 통한 매개 변수 인터랙션
postgresql.conf, 환경 설정 파일을 통한 매개 변수 인터랙션
postgres_fdw, postgres_fdw
postmaster, postmaster
post_auth_delay 환경 설정 매개 변수, 개발자 옵션
power, Mathematical Functions and Operators
PQbackendPID, Connection Status Functions
PQbinaryTuples, Retrieving Query Result Information
with COPY, Functions Associated with the COPY Command
PQcancel, Canceling Queries in Progress
PQclear, Main Functions
PQclientEncoding, Control Functions
PQcmdStatus, Retrieving Other Result Information
PQcmdTuples, Retrieving Other Result Information
PQconndefaults, Database Connection Control Functions
PQconnectdb, Database Connection Control Functions
PQconnectdbParams, Database Connection Control Functions
PQconnectionNeedsPassword, Connection Status Functions
PQconnectionUsedPassword, Connection Status Functions
PQconnectPoll, Database Connection Control Functions
PQconnectStart, Database Connection Control Functions
PQconnectStartParams, Database Connection Control Functions
PQconninfo, Database Connection Control Functions
PQconninfoFree, Miscellaneous Functions
PQconninfoParse, Database Connection Control Functions
PQconsumeInput, Asynchronous Command Processing
PQcopyResult, Miscellaneous Functions
PQdb, Connection Status Functions
PQdescribePortal, Main Functions
PQdescribePrepared, Main Functions
PQencryptPassword, Miscellaneous Functions
PQencryptPasswordConn, Miscellaneous Functions
PQendcopy, Obsolete Functions for COPY
PQerrorMessage, Connection Status Functions
PQescapeBytea, Escaping Strings for Inclusion in SQL Commands
PQescapeByteaConn, Escaping Strings for Inclusion in SQL Commands
PQescapeIdentifier, Escaping Strings for Inclusion in SQL Commands
PQescapeLiteral, Escaping 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
PQfireResultCreateEvents, Miscellaneous 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, Canceling Queries in Progress
PQfreemem, Miscellaneous Functions
PQfsize, Retrieving Query Result Information
PQftable, Retrieving Query Result Information
PQftablecol, Retrieving Query Result Information
PQftype, Retrieving Query Result Information
PQgetCancel, Canceling 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
PQgetSSLKeyPassHook_OpenSSL, Database Connection Control Functions
PQgetvalue, Retrieving Query Result Information
PQhost, Connection Status Functions
PQhostaddr, Connection Status Functions
PQinitOpenSSL, SSL Library Initialization
PQinitSSL, SSL Library Initialization
PQinstanceData, Event Support Functions
PQisBusy, Asynchronous Command Processing
PQisnonblocking, Asynchronous Command Processing
PQisthreadsafe, Behavior in Threaded Programs
PQlibVersion, Miscellaneous Functions
([살펴볼 다른 내용] PQserverVersion)
PQmakeEmptyPGresult, Miscellaneous Functions
PQnfields, Retrieving Query Result Information
with COPY, Functions Associated with the COPY Command
PQnotifies, Asynchronous Notification
PQnparams, Retrieving Query Result Information
PQntuples, Retrieving Query Result Information
PQoidStatus, Retrieving Other Result Information
PQoidValue, Retrieving Other Result Information
PQoptions, Connection Status Functions
PQparameterStatus, Connection Status Functions
PQparamtype, Retrieving Query Result Information
PQpass, Connection Status Functions
PQping, Database Connection Control Functions
PQpingParams, Database Connection Control 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
PQregisterEventProc, Event Support Functions
PQrequestCancel, Canceling Queries in Progress
PQreset, Database Connection Control Functions
PQresetPoll, Database Connection Control Functions
PQresetStart, Database Connection Control Functions
PQresStatus, Main Functions
PQresultAlloc, Miscellaneous Functions
PQresultErrorField, Main Functions
PQresultErrorMessage, Main Functions
PQresultInstanceData, Event Support Functions
PQresultMemorySize, Miscellaneous Functions
PQresultSetInstanceData, Event Support Functions
PQresultStatus, Main Functions
PQresultVerboseErrorMessage, Main Functions
PQsendDescribePortal, Asynchronous Command Processing
PQsendDescribePrepared, Asynchronous Command Processing
PQsendPrepare, Asynchronous Command Processing
PQsendQuery, Asynchronous Command Processing
PQsendQueryParams, Asynchronous Command Processing
PQsendQueryPrepared, Asynchronous Command Processing
PQserverVersion, Connection Status Functions
PQsetClientEncoding, Control Functions
PQsetdb, Database Connection Control Functions
PQsetdbLogin, Database Connection Control Functions
PQsetErrorContextVisibility, Control Functions
PQsetErrorVerbosity, Control Functions
PQsetInstanceData, Event Support Functions
PQsetnonblocking, Asynchronous Command Processing
PQsetNoticeProcessor, Notice Processing
PQsetNoticeReceiver, Notice Processing
PQsetResultAttrs, Miscellaneous Functions
PQsetSingleRowMode, Retrieving Query Results Row-by-Row
PQsetSSLKeyPassHook_OpenSSL, Database Connection Control Functions
PQsetvalue, Miscellaneous Functions
PQsocket, Connection Status Functions
PQsslAttribute, Connection Status Functions
PQsslAttributeNames, Connection Status Functions
PQsslInUse, Connection Status Functions
PQsslStruct, Connection Status Functions
PQstatus, Connection Status Functions
PQtrace, Control Functions
PQtransactionStatus, Connection Status Functions
PQtty, Connection Status Functions
PQunescapeBytea, Escaping Strings for Inclusion in SQL Commands
PQuntrace, Control Functions
PQuser, Connection Status Functions
predicate locking, Serializable Isolation Level
PREPARE, PREPARE
PREPARE TRANSACTION, PREPARE TRANSACTION
prepared statements, DEALLOCATE, EXECUTE, EXPLAIN, PREPARE
creating, PREPARE
executing, EXECUTE
삭제, DEALLOCATE
쿼리 실행 계획 보기, EXPLAIN
preparing a query
in PL/pgSQL, Plan Caching
in PL/Python, Database Access Functions
in PL/Tcl, Database Access from PL/Tcl
pre_auth_delay 환경 설정 매개 변수, 개발자 옵션
primary key, Primary Keys
primary_conninfo configuration parameter, 대기 서버
primary_slot_name configuration parameter, 대기 서버
privilege, Privileges, Schemas and Privileges, Rules and Privileges, Rules and Privileges
querying, System Information Functions and Operators
with rules, Rules and Privileges
for schemas, Schemas and Privileges
with views, Rules and Privileges
procedural language, Procedural Languages, Writing a Procedural Language Handler
externally maintained, Procedural Languages
handler for, Writing a Procedural Language Handler
procedure, User-Defined Procedures
user-defined, User-Defined Procedures
promote_trigger_file configuration parameter, 대기 서버
protocol, Frontend/Backend Protocol
frontend-backend, Frontend/Backend Protocol
ps, 표준 유닉스 도구들
프로세스 살펴 보기, 표준 유닉스 도구들
psql, 데이터베이스 사용하기, psql
Python, PL/Python — Python Procedural Language

Q

qualified name, Creating a Schema
query, Queries
query plan, Using EXPLAIN
query tree, The Query Tree
querytree, Text Search Functions and Operators, Manipulating Queries
quotation marks
and identifiers, Identifiers and Key Words
escaping, String Constants
quote_all_identifiers 환경 설정 매개 변수, 이전 PostgreSQL 버전
quote_ident, String Functions and Operators
in PL/Perl, Utility Functions in PL/Perl
use in PL/pgSQL, Executing Dynamic Commands
quote_literal, String Functions and Operators
in PL/Perl, Utility Functions in PL/Perl
use in PL/pgSQL, Executing Dynamic Commands
quote_nullable, String Functions and Operators
in PL/Perl, Utility Functions in PL/Perl
use in PL/pgSQL, Executing Dynamic Commands

R

radians, Mathematical Functions and Operators
radius, Geometric Functions and Operators
RADIUS, RADIUS 인증
RAISE
in PL/pgSQL, Reporting Errors and Messages
random, Mathematical Functions and Operators
random_page_cost 환경 설정 매개 변수, 플래너 비용 상수
range table, The Query Tree
range type, Range Types
exclude, Constraints on Ranges
indexes on, Indexing
range_merge, Range Functions and Operators
rank, Window Functions
hypothetical, Aggregate Functions
read committed, 커밋된 읽기 격리 수준
read-only transaction
setting, SET TRANSACTION
setting default, 문 동작
readline, Requirements
real, Floating-Point Types
REASSIGN OWNED, REASSIGN OWNED
record, Pseudo-Types
recovery.conf, recovery.conf file merged into postgresql.conf
recovery.signal, Archive Recovery
recovery_end_command configuration parameter, Archive Recovery
recovery_min_apply_delay configuration parameter, 대기 서버
recovery_target configuration parameter, Recovery Target
recovery_target_action configuration parameter, Recovery Target
recovery_target_inclusive configuration parameter, Recovery Target
recovery_target_lsn configuration parameter, Recovery Target
recovery_target_name configuration parameter, Recovery Target
recovery_target_time configuration parameter, Recovery Target
recovery_target_timeline configuration parameter, Recovery Target
recovery_target_xid configuration parameter, Recovery Target
rectangle, Boxes
RECURSIVE, CREATE VIEW
in common table expressions, SELECT in WITH
뷰에서, CREATE VIEW
referential integrity, Foreign Keys
REFRESH MATERIALIZED VIEW, REFRESH MATERIALIZED VIEW
regclass, Object Identifier Types
regcollation, Object Identifier Types
regconfig, Object Identifier Types
regdictionary, Object Identifier Types
regexp_match, String Functions and Operators, POSIX Regular Expressions
regexp_matches, String Functions and Operators, POSIX Regular Expressions
regexp_replace, String Functions and Operators, POSIX Regular Expressions
regexp_split_to_array, String Functions and Operators, POSIX Regular Expressions
regexp_split_to_table, String Functions and Operators, POSIX Regular Expressions
regnamespace, Object Identifier Types
regoper, Object Identifier Types
regoperator, Object Identifier Types
regproc, Object Identifier Types
regprocedure, Object Identifier Types
regression intercept, Aggregate Functions
regression slope, Aggregate Functions
regression test, Installation Procedure
regression tests, Regression Tests
regrole, Object Identifier Types
regr_avgx, Aggregate Functions
regr_avgy, Aggregate Functions
regr_count, Aggregate Functions
regr_intercept, Aggregate Functions
regr_r2, Aggregate Functions
regr_slope, Aggregate Functions
regr_sxx, Aggregate Functions
regr_sxy, Aggregate Functions
regr_syy, Aggregate Functions
regtype, Object Identifier Types
regular expression, SIMILAR TO Regular Expressions, POSIX Regular Expressions
([살펴볼 다른 내용] pattern matching)
reindex, 정기적인 인덱스 다시 만들기
REINDEX, REINDEX
reindexdb, reindexdb
relation, 개념
relational database, 개념
RELEASE SAVEPOINT, RELEASE SAVEPOINT
repeat, String Functions and Operators
repeatable read, Repeatable Read Isolation Level
replace, String Functions and Operators
replication, 고가용성, 부하 분산, 복제
Replication Origins, Replication Progress Tracking
Replication Progress Tracking, Replication Progress Tracking
replication slot
streaming replication, 복제 슬롯
reporting errors
in PL/pgSQL, Reporting Errors and Messages
RESET, RESET
restartpoint, WAL 환경 설정
restart_after_crash 환경 설정 매개 변수, 에러 처리
restore_command configuration parameter, Archive Recovery
RESTRICT, Dependency Tracking
with DROP, Dependency Tracking
foreign key action, Foreign Keys
RETURN NEXT
in PL/pgSQL, RETURN NEXT and RETURN QUERY
RETURN QUERY
in PL/pgSQL, RETURN NEXT and RETURN QUERY
RETURNING, Returning Data from Modified Rows
RETURNING INTO, Executing a Query with a Single-Row Result
in PL/pgSQL, Executing a Query with a Single-Row Result
reverse, String Functions and Operators
REVOKE, Privileges, REVOKE
right, String Functions and Operators
right join, Joined Tables
role, 데이터베이스 role, role 멤버십, Default Roles
applicable, applicable_roles
enabled, enabled_roles
멤버십 in, role 멤버십
복제 초기화 권한, role 속성
생성 권한, role 속성
ROLLBACK, ROLLBACK
rollback
psql, Variables
ROLLBACK PREPARED, ROLLBACK PREPARED
ROLLBACK TO SAVEPOINT, ROLLBACK TO SAVEPOINT
ROLLUP, GROUPING SETS, CUBE, and ROLLUP
round, Mathematical Functions and Operators
routine, User-Defined Procedures
row, 개념, Table Basics
ROW, Row Constructors
row estimation, Row Estimation Examples
multivariate, Multivariate Statistics Examples
planner, Row Estimation Examples
row type, Composite Types
constructor, Row Constructors
row-level security, Row Security Policies
row-wise comparison, Row and Array Comparisons
row_number, Window Functions
row_security 환경 설정 매개 변수, 문 동작
row_security_active, System Information Functions and Operators
row_to_json, Processing and Creating JSON Data
rpad, String Functions and Operators
rtrim, String Functions and Operators
rule, The Rule System, Views and the Rule System, How SELECT Rules Work, Materialized Views, Rules on INSERT, UPDATE, and DELETE, Rules on INSERT, UPDATE, and DELETE, Rules on INSERT, UPDATE, and DELETE, Rules Versus Triggers
and materialized views, Materialized Views
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, RELEASE SAVEPOINT, ROLLBACK TO SAVEPOINT, SAVEPOINT
defining, SAVEPOINT
releasing, RELEASE SAVEPOINT
rolling back, ROLLBACK TO SAVEPOINT
scalar (살펴볼 내용 expression)
scale, Mathematical Functions and Operators
schema, Schemas, Creating a Schema, The Public Schema
creating, Creating a Schema
current, The Schema Search Path, System Information Functions and Operators
public, The Public Schema
removing, Creating a Schema
SCRAM, 패스워드 인증
search path, The Schema Search Path
current, System Information Functions and Operators
object visibility, System Information Functions and Operators
search_path configuration parameter, The Schema Search Path
search_path 환경 변수 매개 변수
함수 보안, SECURITY DEFINER 함수를 안전하게 만드는 방법
search_path 환경 설정 매개 변수, 문 동작
SECURITY LABEL, SECURITY LABEL
sec_to_gc, Cube-Based Earth Distances
seg, seg
segment_size 환경 설정 매개 변수, 프리셋 옵션
SELECT, 테이블에 있는 자료 조회하기, Queries, SELECT Output Columns, SELECT
determination of result type, SELECT Output Columns
select list, Select Lists
SELECT INTO, Executing a Query with a Single-Row Result, SELECT INTO
in PL/pgSQL, Executing a Query with a Single-Row Result
sepgsql, sepgsql
sepgsql.debug_audit configuration parameter, GUC Parameters
sepgsql.permissive configuration parameter, GUC Parameters
sequence, Sequence Manipulation Functions
and serial type, Serial Types
sequential scan, 플래너 방법 환경 설정
seq_page_cost 환경 설정 매개 변수, 플래너 비용 상수
serial, Serial Types
serial2, Serial Types
serial4, Serial Types
serial8, Serial Types
serializable, Serializable Isolation Level
Serializable Snapshot Isolation, 소개
serialization anomaly, 트랜잭션 격리, Serializable Isolation Level
server 로그, 에러 리포팅 및 로깅
server_encoding 환경 설정 매개 변수, 프리셋 옵션
server_version 환경 설정 매개 변수, 프리셋 옵션
server_version_num 환경 설정 매개 변수, 프리셋 옵션
session_preload_libraries 환경 설정 매개 변수, 공유 라이브러리 사전 로드
session_replication_role 환경 설정 매개 변수, 문 동작
session_user, System Information Functions and Operators
SET, Configuration Settings Functions, SET
SET CONSTRAINTS, SET CONSTRAINTS
set difference, Combining Queries
set intersection, Combining Queries
set operation, Combining Queries
set returning functions, 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
SET XML OPTION, 문 동작
setseed, Mathematical Functions and Operators
setval, Sequence Manipulation Functions
setweight, Text Search Functions and Operators, Manipulating Documents
setweight for specific lexeme(s), Text Search Functions and Operators
set_bit, Binary String Functions and Operators, Bit String Functions and Operators
set_byte, Binary String Functions and Operators
set_config, Configuration Settings Functions
set_limit, Functions and Operators
set_masklen, Network Address Functions and Operators
sha224, Binary String Functions and Operators
sha256, Binary String Functions and Operators
sha384, Binary String Functions and Operators
sha512, Binary String Functions and Operators
shared library, Shared Libraries, Compiling and Linking Dynamically-Loaded Functions
shared_buffers 환경 설정 매개 변수, 메모리
shared_memory_type configuration parameter, 메모리
shared_preload_libraries, Shared Memory and LWLocks
shared_preload_libraries 환경 설정 매개 변수, 공유 라이브러리 사전 로드
shobj_description, System Information Functions and Operators
SHOW, Configuration Settings Functions, SHOW, Streaming Replication Protocol
show_limit, Functions and Operators
show_trgm, Functions and Operators
SIGHUP, 환경 설정 파일을 통한 매개 변수 인터랙션, The pg_hba.conf 파일, 사용자 이름 맵
SIGINT, 서버 셧다운
sign, Mathematical Functions and Operators
signal
backend processes, Server Signaling Functions
significant digits, 로케일(locale) 및 출력 양식
SIGQUIT, 서버 셧다운
SIGTERM, 서버 셧다운
SIMILAR TO, SIMILAR TO Regular Expressions
similarity, Functions and Operators
sin, Mathematical Functions and Operators
sind, Mathematical Functions and Operators
sinh, Mathematical Functions and Operators
skeys, hstore Operators and Functions
sleep, Delaying Execution
slice, hstore Operators and Functions
sliced bread (살펴볼 내용 TOAST)
slope, Geometric Functions and Operators
SLRU, pg_stat_slru
smallint, Integer Types
smallserial, Serial Types
Solaris, Solaris
installation on, Solaris
shared library, Compiling and Linking Dynamically-Loaded Functions
시작 스크립트, 데이터베이스 서버 시작
SOME, Aggregate Functions, Subquery Expressions, Row and Array Comparisons
sort, intarray 함수와 연산자들
sorting, Sorting Rows
sort_asc, intarray 함수와 연산자들
sort_desc, intarray 함수와 연산자들
soundex, Soundex
SP-GiST (살펴볼 내용 index)
SPI, Server Programming Interface, spi
examples, spi
spi_commit
in PL/Perl, Database Access from PL/Perl
SPI_commit, SPI_commit
SPI_commit_and_chain, SPI_commit
SPI_connect, SPI_connect
SPI_connect_ext, SPI_connect
SPI_copytuple, SPI_copytuple
spi_cursor_close
in PL/Perl, Database Access from PL/Perl
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_cursor_open_with_args, SPI_cursor_open_with_args
SPI_cursor_open_with_paramlist, SPI_cursor_open_with_paramlist
SPI_exec, SPI_exec
SPI_execp, SPI_execp
SPI_execute, SPI_execute
SPI_execute_plan, SPI_execute_plan
SPI_execute_plan_with_paramlist, SPI_execute_plan_with_paramlist
SPI_execute_with_args, SPI_execute_with_args
spi_exec_prepared
in PL/Perl, Database Access from PL/Perl
spi_exec_query
in PL/Perl, Database Access from PL/Perl
spi_fetchrow
in PL/Perl, Database Access from PL/Perl
SPI_finish, SPI_finish
SPI_fname, SPI_fname
SPI_fnumber, SPI_fnumber
spi_freeplan
in PL/Perl, Database Access from PL/Perl
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_keepplan, SPI_keepplan
SPI_modifytuple, SPI_modifytuple
SPI_palloc, SPI_palloc
SPI_pfree, SPI_pfree
spi_prepare
in PL/Perl, Database Access from PL/Perl
SPI_prepare, SPI_prepare
SPI_prepare_cursor, SPI_prepare_cursor
SPI_prepare_params, SPI_prepare_params
spi_query
in PL/Perl, Database Access from PL/Perl
spi_query_prepared
in PL/Perl, Database Access from PL/Perl
SPI_register_relation, SPI_register_relation
SPI_register_trigger_data, SPI_register_trigger_data
SPI_repalloc, SPI_repalloc
SPI_result_code_string, SPI_result_code_string
SPI_returntuple, SPI_returntuple
spi_rollback
in PL/Perl, Database Access from PL/Perl
SPI_rollback, SPI_rollback
SPI_rollback_and_chain, SPI_rollback
SPI_saveplan, SPI_saveplan
SPI_scroll_cursor_fetch, SPI_scroll_cursor_fetch
SPI_scroll_cursor_move, SPI_scroll_cursor_move
SPI_start_transaction, SPI_start_transaction
SPI_unregister_relation, SPI_unregister_relation
split_part, String Functions and Operators
SQL/CLI, SQL Conformance
SQL/Foundation, SQL Conformance
SQL/Framework, SQL Conformance
SQL/JRT, SQL Conformance
SQL/JSON path language, The SQL/JSON Path Language
SQL/MDA, SQL Conformance
SQL/MED, SQL Conformance
SQL/OLB, SQL Conformance
SQL/PSM, SQL Conformance
SQL/Schemata, SQL Conformance
SQL/XML, SQL Conformance
limits and conformance, XML Limits and Conformance to SQL/XML
sqrt, Mathematical Functions and Operators
ssh, SSH 터널을 사용하여 TCP/IP 연결 보호
SSI, 소개
SSL, SSL을 사용한 TCP/IP 연결 보호, SSL Support
in libpq, Connection Status Functions
with libpq, Parameter Key Words
ssl 환경 설정 매개 변수, SSL
sslinfo, sslinfo
ssl_ca_file 환경 설정 매개 변수, SSL
ssl_cert_file 환경 설정 매개 변수, SSL
ssl_cipher, Functions Provided
ssl_ciphers 환경 설정 매개 변수, SSL
ssl_client_cert_present, Functions Provided
ssl_client_dn, Functions Provided
ssl_client_dn_field, Functions Provided
ssl_client_serial, Functions Provided
ssl_crl_file 환경 설정 매개 변수, SSL
ssl_dh_params_file configuration parameter, SSL
ssl_ecdh_curve 환경 설정 매개 변수, SSL
ssl_extension_info, Functions Provided
ssl_issuer_dn, Functions Provided
ssl_issuer_field, Functions Provided
ssl_is_used, Functions Provided
ssl_key_file 환경 설정 매개 변수, SSL
ssl_library configuration parameter, 프리셋 옵션
ssl_max_protocol_version configuration parameter, SSL
ssl_min_protocol_version configuration parameter, SSL
ssl_passphrase_command 환경 설정 매개 변수, SSL
ssl_passphrase_command_supports_reload 환경 설정 매개 변수, SSL
ssl_prefer_server_ciphers 환경 설정 매개 변수, SSL
ssl_version, Functions Provided
SSPI, SSPI 인증
STABLE, 휘발성에 따른 함수 분류
standard deviation, Aggregate Functions
population, Aggregate Functions
sample, Aggregate Functions
standard_conforming_strings 환경 설정 매개 변수, 이전 PostgreSQL 버전
standby server, 고가용성, 부하 분산, 복제
standby.signal, Archive Recovery, 대기 서버 동작방식, 대기 서버 구축하기
pg_basebackup --write-recovery-conf, Options
실시간 복제 대기 서버, 관리자 측면 개요
standby_mode (살펴볼 내용 standby.signal)
START TRANSACTION, START TRANSACTION
starts_with, String Functions and Operators
START_REPLICATION, Streaming Replication Protocol
statement_timeout 환경 설정 매개 변수, 문 동작
statement_timestamp, Date/Time Functions and Operators
statistics, Aggregate Functions, Statistics Used by the Planner, Extended Statistics
of the planner, Statistics Used by the Planner, Extended Statistics
stats_temp_directory 환경 설정 매개 변수, 쿼리 및 인덱스 통계 수집기
stddev, Aggregate Functions
stddev_pop, Aggregate Functions
stddev_samp, Aggregate Functions
STONITH, 고가용성, 부하 분산, 복제
strict_word_similarity, Functions and Operators
string (살펴볼 내용 character string)
strings
backslash quotes, 이전 PostgreSQL 버전
escape warning, 이전 PostgreSQL 버전
standard conforming, 이전 PostgreSQL 버전
string_agg, Aggregate Functions
string_to_array, Array Functions and Operators
strip, Text Search Functions and Operators, Manipulating Documents
strpos, String Functions and Operators
subarray, intarray 함수와 연산자들
subltree, Operators and Functions
subpath, Operators and Functions
subquery, 집계 함수, Scalar Subqueries, Subqueries, Subquery Expressions
subscript, Subscripts
substr, String Functions and Operators, Binary String Functions and Operators
substring, String Functions and Operators, Binary String Functions and Operators, Bit String Functions and Operators, SIMILAR TO Regular Expressions, POSIX Regular Expressions
subtransactions
in PL/Tcl, Explicit Subtransactions in PL/Tcl
sum, Aggregate Functions
superuser, 데이터베이스 사용하기
superuser_reserved_connections 환경 설정 매개 변수, 접속 설정
support functions
in_range, B-Tree Support Functions
suppress_redundant_updates_trigger, Trigger Functions
svals, hstore Operators and Functions
synchronize_seqscans 환경 설정 매개 변수, 이전 PostgreSQL 버전
Synchronous Replication, 고가용성, 부하 분산, 복제
synchronous_commit 환경 설정 매개 변수, 설정
synchronous_standby_names 환경 설정 매개 변수, 마스터 서버
syntax, SQL Syntax
SQL, SQL Syntax
syslog_facility 환경 설정 매개 변수, Where To 로그
syslog_ident 환경 설정 매개 변수, Where To 로그
syslog_sequence_numbers configuration parameter, Where To 로그
syslog_split_messages configuration parameter, Where To 로그
system catalog, The System Catalog Schema
schema, The System Catalog Schema
systemd, PostgreSQL Features, 데이터베이스 서버 시작
RemoveIPC, systemd RemoveIPC

T

table, 개념, Table Basics, Modifying Tables
creating, Table Basics
inheritance, Inheritance
modifying, Modifying Tables
partitioning, Table Partitioning
removing, Table Basics
renaming, Renaming a Table
Table Access Method, Table Access Method Interface Definition
TABLE command, SELECT
table expression, Table Expressions
table function, Table Functions, xmltable
XMLTABLE, xmltable
table sampling method, Writing a Table Sampling Method
tableam
Table Access Method, Table Access Method Interface Definition
tablefunc, tablefunc
tableoid, System Columns
TABLESAMPLE method, Writing a Table Sampling Method
tablespace
default, 문 동작
temporary, 문 동작
table_am_handler, Pseudo-Types
tan, Mathematical Functions and Operators
tand, Mathematical Functions and Operators
tanh, Mathematical Functions and Operators
target list, The Query Tree
Tcl, PL/Tcl — Tcl Procedural Language
tcn, tcn
tcp_keepalives_count 환경 설정 매개 변수, 접속 설정
tcp_keepalives_idle 환경 설정 매개 변수, 접속 설정
tcp_keepalives_interval 환경 설정 매개 변수, 접속 설정
tcp_user_timeout 환경 설정 매개 변수, 접속 설정
template0, 템플릿 데이터베이스
template1, 데이터베이스 생성, 템플릿 데이터베이스
temp_buffers 환경 설정 매개 변수, 메모리
temp_file_limit 환경 설정 매개 변수, 디스크
temp_tablespaces 환경 설정 매개 변수, 문 동작
test, Regression Tests
test_decoding, test_decoding
text, Character Types, Network Address Functions and Operators
text search, Text Search Types, Text Search Types, Full Text Search, GIN and GiST Index Types
data types, Text Search Types
functions and operators, Text Search Types
indexes, GIN and GiST Index Types
text2ltree, Operators and Functions
threads, Behavior in Threaded Programs
with libpq, Behavior in Threaded Programs
tid, Object Identifier Types
time, Date/Time Types, Times
constants, Special Values
current, Current Date/Time
output format, Date/Time Output
([살펴볼 다른 내용] formatting)
time span, Date/Time Types
time with time zone, Date/Time Types, Times
time without time zone, Date/Time Types, Times
time zone, Time Zones, 로케일(locale) 및 출력 양식, POSIX Time Zone Specifications
conversion, AT TIME ZONE
input abbreviations, Date/Time Configuration Files
POSIX-style specification, POSIX Time Zone Specifications
time zone data, Build Process Details
time zone names, 로케일(locale) 및 출력 양식
TIMELINE_HISTORY, Streaming Replication Protocol
timeofday, Date/Time Functions and Operators
timeout
deadlock, 잠금(lock) 관리
클라이언트 인증, 인증
timestamp, Date/Time Types, Time Stamps
timestamp with time zone, Date/Time Types, Time Stamps
timestamp without time zone, Date/Time Types, Time Stamps
timestamptz, Date/Time Types
TimeZone 환경 설정 매개 변수, 로케일(locale) 및 출력 양식
timezone_abbreviations 환경 설정 매개 변수, 로케일(locale) 및 출력 양식
TOAST, TOAST
and user-defined types, TOAST Considerations
per-type storage settings, 설명
versus large objects, Introduction
칼럼별 자료 저장 방식 설정, 설명
toast_tuple_target storage parameter, 스토리지 매개 변수
token, Lexical Structure
to_ascii, String Functions and Operators
to_char, Data Type Formatting Functions
및 로케일, 동작
to_date, Data Type Formatting Functions
to_hex, String Functions and Operators
to_json, Processing and Creating JSON Data
to_jsonb, Processing and Creating JSON Data
to_number, Data Type Formatting Functions
to_regclass, System Information Functions and Operators
to_regcollation, System Information Functions and Operators
to_regnamespace, System Information Functions and Operators
to_regoper, System Information Functions and Operators
to_regoperator, System Information Functions and Operators
to_regproc, System Information Functions and Operators
to_regprocedure, System Information Functions and Operators
to_regrole, System Information Functions and Operators
to_regtype, System Information Functions and Operators
to_timestamp, Data Type Formatting Functions, Date/Time Functions and Operators
to_tsquery, Text Search Functions and Operators, Parsing Queries
to_tsvector, Text Search Functions and Operators, Parsing Documents
trace_locks 환경 설정 매개 변수, 개발자 옵션
trace_lock_oidmin 환경 설정 매개 변수, 개발자 옵션
trace_lock_table 환경 설정 매개 변수, 개발자 옵션
trace_lwlocks 환경 설정 매개 변수, 개발자 옵션
trace_notify 환경 설정 매개 변수, 개발자 옵션
trace_recovery_messages 환경 설정 매개 변수, 개발자 옵션
trace_sort 환경 설정 매개 변수, 개발자 옵션
trace_userlocks 환경 설정 매개 변수, 개발자 옵션
track_activities 환경 설정 매개 변수, 쿼리 및 인덱스 통계 수집기
track_activity_query_size 환경 설정 매개 변수, 쿼리 및 인덱스 통계 수집기
track_commit_timestamp 환경 설정 매개 변수, 전송 서버들
track_counts 환경 설정 매개 변수, 쿼리 및 인덱스 통계 수집기
track_functions 환경 설정 매개 변수, 쿼리 및 인덱스 통계 수집기
track_io_timing 환경 설정 매개 변수, 쿼리 및 인덱스 통계 수집기
transaction, 트랜잭션
transaction isolation, 트랜잭션 격리
transaction isolation level
read committed, 커밋된 읽기 격리 수준
repeatable read, Repeatable Read Isolation Level
serializable, Serializable Isolation Level
setting, SET TRANSACTION
setting default, 문 동작
transaction_timestamp, Date/Time Functions and Operators
transform_null_equals 환경 설정 매개 변수, 플랫폼 및 클라이언트 호환성
transition tables, CREATE TRIGGER
([살펴볼 다른 내용] ephemeral named relation)
implementation in PLs, SPI_register_trigger_data
referencing from C trigger, Writing Trigger Functions in C
translate, String Functions and Operators
transparent huge pages, 메모리
trigger, Pseudo-Types, Triggers, Writing Trigger Functions in C, Rules Versus Triggers, Trigger Functions, Trigger Functions
arguments for trigger functions, Overview of Trigger Behavior
for updating a derived tsvector column, Triggers for Automatic Updates
in C, Writing Trigger Functions in C
in PL/pgSQL, Trigger Functions
in PL/Python, Trigger Functions
in PL/Tcl, Trigger Functions in PL/Tcl
compared with rules, Rules Versus Triggers
triggered_change_notification, tcn
trigger_file (살펴볼 내용 promote_trigger_file)
trim, String Functions and Operators, Binary String Functions and Operators
trim_scale, Mathematical Functions and Operators
true, Boolean Type
trunc, Mathematical Functions and Operators, Network Address Functions and Operators
TRUNCATE, TRUNCATE
trusted, Trusted and Untrusted PL/Perl
PL/Perl, Trusted and Untrusted PL/Perl
tsm_handler, Pseudo-Types
tsm_system_rows, tsm_system_rows
tsm_system_time, tsm_system_time
tsquery (data type), tsquery
tsquery_phrase, Text Search Functions and Operators, Manipulating Queries
tsvector (data type), tsvector
tsvector concatenation, Manipulating Documents
tsvector_to_array, Text Search Functions and Operators
tsvector_update_trigger, Trigger Functions
tsvector_update_trigger_column, Trigger Functions
ts_debug, Text Search Functions and Operators, Configuration Testing
ts_delete, Text Search Functions and Operators
ts_filter, Text Search Functions and Operators
ts_headline, Text Search Functions and Operators, Highlighting Results
ts_lexize, Text Search Functions and Operators, Dictionary Testing
ts_parse, Text Search Functions and Operators, Parser Testing
ts_rank, Text Search Functions and Operators, Ranking Search Results
ts_rank_cd, Text Search Functions and Operators, Ranking Search Results
ts_rewrite, Text Search Functions and Operators, Query Rewriting
ts_stat, Text Search Functions and Operators, Gathering Document Statistics
ts_token_type, Text Search Functions and Operators, Parser Testing
tuple_data_split, Heap Functions
txid_current, System Information Functions and Operators
txid_current_if_assigned, System Information Functions and Operators
txid_current_snapshot, System Information Functions and Operators
txid_snapshot_xip, System Information Functions and Operators
txid_snapshot_xmax, System Information Functions and Operators
txid_snapshot_xmin, System Information Functions and Operators
txid_status, System Information Functions and Operators
txid_visible_in_snapshot, System Information Functions and Operators
type (살펴볼 내용 data type)
type cast, Numeric Constants, Type Casts

U

UESCAPE, Identifiers and Key Words, String Constants with Unicode Escapes
unaccent, unaccent, Functions
Unicode escape, String Constants with Unicode Escapes
in identifiers, Identifiers and Key Words
in string constants, String Constants with Unicode Escapes
Unicode normalization, String Functions and Operators
UNION, Combining Queries, UNION, CASE, and Related Constructs
determination of result type, UNION, CASE, and Related Constructs
uniq, intarray 함수와 연산자들
unique constraint, Unique Constraints
Unix domain socket, Parameter Key Words
unix_socket_directories 환경 설정 매개 변수, 접속 설정
unix_socket_group 환경 설정 매개 변수, 접속 설정
unix_socket_permissions 환경 설정 매개 변수, 접속 설정
unknown, Pseudo-Types
UNLISTEN, UNLISTEN
unnest, Array Functions and Operators
for tsvector, Text Search Functions and Operators
unqualified name, The Schema Search Path
UPDATE, 자료 갱신, Updating Data, Returning Data from Modified Rows, UPDATE
RETURNING, Returning Data from Modified Rows
update_process_title 환경 설정 매개 변수, 프로세스 제목
updating, Updating Data
upper, String Functions and Operators, Range Functions and Operators
및 로케일, 동작
upper_inc, Range Functions and Operators
upper_inf, Range Functions and Operators
UPSERT, INSERT
URI, Connection Strings
user, System Information Functions and Operators
current, System Information Functions and Operators
user mapping, Foreign Data
user_catalog_table storage parameter, 스토리지 매개 변수
UUID, UUID Type, UUID Type, PostgreSQL Features
generating, UUID Type
uuid-ossp, uuid-ossp
uuid_generate_v1, uuid-ossp Functions
uuid_generate_v1mc, uuid-ossp Functions
uuid_generate_v3, uuid-ossp Functions

V

vacuum, 정기적인 Vacuum 작업
VACUUM, VACUUM
vacuumdb, vacuumdb
vacuumlo, vacuumlo
vacuum_cost_delay 환경 설정 매개 변수, 비용 기반 청소 지연
vacuum_cost_limit 환경 설정 매개 변수, 비용 기반 청소 지연
vacuum_cost_page_dirty 환경 설정 매개 변수, 비용 기반 청소 지연
vacuum_cost_page_hit 환경 설정 매개 변수, 비용 기반 청소 지연
vacuum_cost_page_miss 환경 설정 매개 변수, 비용 기반 청소 지연
vacuum_defer_cleanup_age 환경 설정 매개 변수, 마스터 서버
vacuum_freeze_min_age 환경 설정 매개 변수, 문 동작
vacuum_freeze_table_age 환경 설정 매개 변수, 문 동작
vacuum_index_cleanup storage parameter, 스토리지 매개 변수
vacuum_multixact_freeze_min_age 환경 설정 매개 변수, 문 동작
vacuum_multixact_freeze_table_age 환경 설정 매개 변수, 문 동작
vacuum_truncate storage parameter, 스토리지 매개 변수
value expression, Value Expressions
VALUES, VALUES Lists, UNION, CASE, and Related Constructs, VALUES
determination of result type, UNION, CASE, and Related Constructs
varchar, Character Types
variance, Aggregate Functions
population, Aggregate Functions
sample, Aggregate Functions
var_pop, Aggregate Functions
var_samp, Aggregate Functions
version, 데이터베이스 사용하기, System Information Functions and Operators
view, 뷰, Views and the Rule System, Materialized Views, Cooperation with Views
implementation through rules, Views and the Rule System
materialized, Materialized Views
updating, Cooperation with Views
Visibility Map, Visibility Map
VM (살펴볼 내용 Visibility Map)
void, Pseudo-Types
VOLATILE, 휘발성에 따른 함수 분류
VPATH, Installation Procedure, Extension Building Infrastructure

W

WAL, 안정성 및 Write-Ahead 로그
wal_block_size 환경 설정 매개 변수, 프리셋 옵션
wal_buffers 환경 설정 매개 변수, 설정
wal_compression 환경 설정 매개 변수, 설정
wal_consistency_checking configuration parameter, 개발자 옵션
wal_debug 환경 설정 매개 변수, 개발자 옵션
wal_init_zero configuration parameter, 설정
wal_keep_size 환경 설정 매개 변수, 전송 서버들
wal_level 환경 설정 매개 변수, 설정
wal_log_hints 환경 설정 매개 변수, 설정
wal_receiver_create_temp_slot configuration parameter, 대기 서버
wal_receiver_status_interval 환경 설정 매개 변수, 대기 서버
wal_receiver_timeout 환경 설정 매개 변수, 대기 서버
wal_recycle configuration parameter, 설정
wal_retrieve_retry_interval 환경 설정 매개 변수, 대기 서버
wal_segment_size 환경 설정 매개 변수, 프리셋 옵션
wal_sender_timeout 환경 설정 매개 변수, 전송 서버들
wal_skip_threshold 환경 설정 매개 변수, 설정
wal_sync_method 환경 설정 매개 변수, 설정
wal_writer_delay 환경 설정 매개 변수, 설정
wal_writer_flush_after configuration parameter, 설정
warm standby, 고가용성, 부하 분산, 복제
websearch_to_tsquery, Text Search Functions and Operators
WHERE, The WHERE Clause
where to 로그, Where To 로그
WHILE
in PL/pgSQL, WHILE
width, Geometric Functions and Operators
width_bucket, Mathematical Functions and Operators
window function, 윈도우 함수, Window Function Calls, Window Function Processing, Window Functions
built-in, Window Functions
invocation, Window Function Calls
order of execution, Window Function Processing
WITH, WITH Queries (Common Table Expressions), SELECT
in SELECT, WITH Queries (Common Table Expressions), SELECT
WITH CHECK OPTION, CREATE VIEW
WITHIN GROUP, Aggregate Expressions
witness server, 고가용성, 부하 분산, 복제
word_similarity, Functions and Operators
work_mem 환경 설정 매개 변수, 메모리

X

xid, Object Identifier Types
xid8, Object Identifier Types
xmax, System Columns
xmin, System Columns
XML, XML Type
XML export, Mapping Tables to XML
XML Functions, XML Functions
XML option, Creating XML Values, 문 동작
xml2, xml2
xmlagg, xmlagg, Aggregate Functions
xmlbinary 환경 설정 매개 변수, 문 동작
xmlcomment, xmlcomment
xmlconcat, xmlconcat
xmlelement, xmlelement
XMLEXISTS, XMLEXISTS
xmlforest, xmlforest
xmloption 환경 설정 매개 변수, 문 동작
xmlparse, Creating XML Values
xmlpi, xmlpi
xmlroot, xmlroot
xmlserialize, Creating XML Values
xmltable, xmltable
xml_is_well_formed, xml_is_well_formed
xml_is_well_formed_content, xml_is_well_formed
xml_is_well_formed_document, xml_is_well_formed
XPath, xpath
xpath_exists, xpath_exists
xpath_table, xpath_table
XQuery regular expressions, Differences from XQuery (LIKE_REGEX)
xslt_process, xslt_process

Z

zero_damaged_pages 환경 설정 매개 변수, 개발자 옵션
zlib, Requirements, Anti-Features
이전 위로 
참고문헌 처음으로