PostgreSQL: Up and Running, 2nd Edition

Index

Symbols

#> operator, Querying JSON

#>> operator, Querying JSON

&& (overlap) operator, Overlap operator, Exclusion Constraints

-> operator, Querying JSON

->> operator, Querying JSON

: (colon), Shortcuts

<@ (contained) operator, Contains and contained in operators, Binary JSON: jsonb

= (equality) operator, Binary JSON: jsonb

? (key exists) operator, Binary JSON: jsonb

@> (contains) operator, Contains and contained in operators, Binary JSON: jsonb

|| (concatenation) operator, String Functions, Array Slicing and Splicing

~ (similar to) operator, Regular Expressions and Pattern Matching

A

Adminer tool, Adminer

administration tools, Administration Tools–Adminer

adminpack extension, Editing postgresql.conf and pg_hba.conf from pgAdmin

aggregates

FILTER clause and, FILTER Clause for Aggregates–FILTER Clause for Aggregates

PL/V8 and, Writing Aggregate Functions with PL/V8

window functions, Window Functions–ORDER BY

ALTER DATABASE command, Using Schemas, Moving Objects Between Tablespaces

ALTER DEFAULT PRIVILEGES command, Default Privileges

ALTER SEQUENCE command, Serials

ALTER SYSTEM command, Configuration Files, postgresql.conf

ALTER TABLE command, Moving Objects Between Tablespaces, Unique Constraints

ALTER TABLESPACE command, Moving Objects Between Tablespaces, Random Page Cost and Quality of Drives

ALTER TYPE command, TYPE OF

archive_command configuration directive, Configuring the Master

array function, Array Constructors

arrays

about, Arrays

creating, Array Constructors

JSON starting number, Querying JSON

referencing ...