O'Reilly logo

PostgreSQL: Up and Running, 2nd Edition by Leo S. Hsu, Regina O. Obe

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ToolsAdminer
adminpack extension, Editing postgresql.conf and pg_hba.conf from pgAdmin
aggregates
FILTER clause and, FILTER Clause for AggregatesFILTER Clause for Aggregates
PL/V8 and, Writing Aggregate Functions with PL/V8
window functions, Window FunctionsORDER 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required