Index

A

• ACID
  • about / Transaction isolation and multiversion concurrency control
• ACID properties
  • about / ACID properties
  • Atomicity / ACID properties
  • Consistency / ACID properties
  • Isolation / ACID properties
• Advanced Packaging Tool (APT) / Installing PostgreSQL on Ubuntu
• Advanced SQL
  • about / Advanced SQL
  • first records, selecting / Selecting the first records
  • returning functions, setting / Set returning functions
  • lateral subqueries / Lateral subqueries
  • aggregating functions, usage / Advanced usage of aggregating functions
• American chemical society (ACS) / Success stories
• American National Standard Institute (ANSI) / The SQL Language
• ANY function / Common functions of arrays and their operators
• apgdiff
  • URL / Schema difference
• application programming interface (API) / Introduction to JDBC
• arrays
  • about / PostgreSQL arrays
  • common functions / Common functions of arrays and their operators
  • operators / Common functions of arrays and their operators
  • modifying / Modifying and accessing arrays
  • accessing / Modifying and accessing arrays
  • indexing / Indexing arrays in PostgreSQL
• assignment operator
  • URL / Assignment statements
• assignment statement / Assignment statements
• association mapping
  • using / Using association mapping
  • one-to-many and many-to-one mappings / One-to-many and many-to-one mappings
  • one-to-one mappings and component mappings / One-to-one mapping and component mapping
  • many-to-many mappings / Many-to-many mapping
• attribute / Attribute
• authentication
  • about / Authentication in PostgreSQL
  • postgreSQL pg_hba.conf / PostgreSQL pg_hba.conf
  • listen addresses / Listen addresses
  • best practices / Authentication best practices

B

• basically available soft-state, eventual-consistency (BASE) model / The CAP theorem
• best practices, authentication / Authentication best practices
• Block range index (BRIN) / Index types

C

• CAP theorem
  • about / The CAP theorem
  • Consistency / The CAP theorem
  • Availability / The CAP theorem
  • Partition tolerance / The CAP theorem
• character encodings
  • URL / User databases
• client tools version
  • obtaining / Getting the database cluster and client tools version
• columnar databases / Columnar databases
• column level security / Column-level security
• comma-separated values (CSV) / The psql client
• common table expression (CTE) / Very rich SQL constructs
• common table expressions (CTE)
  • about / Common table expressions
  • SQL code, reusing with / Reusing SQL code with CTE
  • recursive and hierarchical queries / Recursive and hierarchical queries
  • data, changing in multiple tables / Changing data in multiple tables at a time
• common table expressions (CTEs) / Using CTE when not mandatory
• concurrency control
  • URL / Transaction isolation and multiversion concurrency control
• conditional statements / Conditional statements
• constraint
  • about / Constraint
  • domain integrity constraint / Domain integrity constraint
  • entity integrity constraint / Entity integrity constraint
  • referential integrity constraints / Referential integrity constraints
  • semantic constraints / Semantic constraints
• constraint exclusion
  • limitations / Constraint exclusion limitations
• CREATE DOMAIN command / The PostgreSQL CREATE DOMAIN command
• create table SQL command
  • URL / Table
• CREATE TYPE command / The PostgreSQL CREATE TYPE command
• cross column correlation / Cross column correlation
• CROSS JOIN (Cartesian product) operation / The CROSS JOIN (Cartesian product) operation
• cursors
  • using / Using cursors
• customer relationship management (CRM) / PostgreSQL applications

D

• data
  • querying, SELECT statement used / Querying the data with the SELECT statement
  • in dataset, changing / Changing the data in the database
  • encrypting / Encrypting data
  • cleaning up, in database / Cleaning up data in the database, How to do it…, There's more…
• data access object (DAO) / The PostgreSQL RESTful API with JSON
• database
  • INSERT statement / INSERT statement
  • UPDATE statement / UPDATE statement
  • DELETE statement / DELETE statement
  • TRUNCATE statement / TRUNCATE statement
  • obtaining / Getting the database and database object size, How to do it…, There's more…
  • object size, obtaining / Getting the database and database object size, How to do it…, There's more…
  • cleaning up / Cleaning up the database, How to do it…, There's more…
  • data, cleaning up / Cleaning up data in the database, How to do it…, There's more…
  • locks, managing / Managing database locks
• database cluster
  • obtaining / Getting the database cluster and client tools version
• database cluster settings
  • setting / Setting and getting database cluster settings, There's more…
  • obtaining / Setting and getting database cluster settings, There's more…
• database coding
  • about / Database coding
  • database naming conventions / Database naming conventions
  • PostgreSQL identifiers / PostgreSQL identifiers
  • documentation / Documentation
  • version control system / Version control system
• database management system (DBMS)
  • about / Database management systems, A brief history
  • database categories / Database categories
  • NoSQL databases / The NoSQL databases
  • relational and object relational databases / Relational and object relational databases
• database security level / Database security level
• Data control language (DCL) / The SQL Language
• Data definition language (DDL) / The SQL Language
• data encryption
  • PostgreSQL role password encryption / PostgreSQL role password encryption
  • pgcrypto extension / pgcrypto
• Data manipulation language (DML) / The SQL Language
• data manipulation language (DML) / The PostgreSQL trigger system
• data modeling
  • about / Data modeling
  • perspectives / Data model perspectives
  • conceptual data model / Data model perspectives
  • logical data model / Data model perspectives
  • physical data model / Data model perspectives
  • entity-relation model / The entity-relation model
  • UML Class Diagrams / UML class diagrams
• DDL statements
  • executing, in dynamic SQL / Executing DDL statements in dynamic SQL
• declaration statement / Declaration statements
• default access privileges
  • about / PostgreSQL default access privileges
  • role system / Role system and proxy authentication
  • proxy authentication / Role system and proxy authentication
• DELETE statement
  • about / DELETE statement
• dklab_pgunit framework
  • URL / Unit test frameworks
• DML statements
  • executing, in dynamic SQL / Executing DML statements in dynamic SQL
• document databases / Document databases
• dynamic SQL
  • about / Dynamic SQL
  • DDL statements, executing / Executing DDL statements in dynamic SQL
  • DML statements, executing / Executing DML statements in dynamic SQL
  • and caching effect / Dynamic SQL and the caching effect
  • practices, recommended / Recommended practices when using dynamic SQL

E

• entities
  • fetching strategies / Fetching strategies
  • fetch type, configuring / Configuring the fetch type
  • fetch mode, configuring / Configuring the fetch mode
  • Hibernate, performance tuning / Tuning the performance of Hibernate
• entity
  • working with / Working with entities
  • states / States of an entity
  • new entity persistent, creating / Making a new entity persistent
  • loading, from database / Loading an entity from the database
  • list of entries, loading / Loading a list of entries
  • named queries / Named queries
  • dynamic queries, creating / Creating dynamic queries
  • modifying / Modifying entities
  • deleting / Deleting entities
  • association mapping, using / Using association mapping
• entity-attribute-value (EAV) / The entity-relation model
• entity-relation model
  • about / The entity-relation model
  • sample application / Sample application
  • entities / Entities, attributes, and keys
  • attributes / Entities, attributes, and keys
  • keys / Entities, attributes, and keys
  • ER, mapping to relations / Mapping ER to Relations
• exception handling
  • about / Exception handling
• EXPLAIN command / The EXPLAIN command and execution plan
• Extensible Markup Language (XML) data type / NoSQL capabilities
• extension
  • about / Extension
  • PostgreSQL data types / Extension

F

• Foreign Data Wrappers (FDW) / PostgreSQL applications
• foreign data wrappers (FDW) / Foreign data wrapper
• foreign data wrappers (FDWs) / The system catalog
• foreign keys
  • missing indexes, adding / Adding missing indexes on foreign keys and altering the default statistic, Getting ready
  • default statistic, altering / Adding missing indexes on foreign keys and altering the default statistic, Getting ready
• For loop statement / The for loop statement
• FROM clause
  • about / FROM clause
  • multiple tables, selecting from / Selecting from multiple tables
  • self-joins / Self-joins
• full text search
  • about / A PostgreSQL full text search
  • tsquery datatypes / The tsquery and tsvector data types, The tsquery data type
  • tsvector datatypes / The tsvector data type
  • pattern matching, affecting factors / Pattern matching
  • pattern matching / Pattern matching
  • indexing / Full text search indexing
• function, handling
  • about / Function handling
  • stored function, calling / Calling a stored function
  • ResultSet, getting from stored function / Getting a ResultSet from a stored function
• function, returning from
  • about / Returning from the function
  • void, returning / Returning void
  • single row, returning / Returning a single row
  • multiple rows, returning / Returning multiple rows
• function call
  • URL / Assignment statements

G

• gaph databases / Graph databases
• generalized inverted index (GIN) / Performance
• Generalized inverted index (GIN) / Index types
• Generalized Search Tree (GiST) / Index types
• Generalized Search Tree (GiST) index / Performance
• GROUP BY clause
  • about / GROUP BY clause
• grouping and aggregation
  • about / Grouping and aggregation

H

• hash store (hstore)
  • about / Hash store
  • modifying / Modifying and accessing an hstore
  • accessing / Modifying and accessing an hstore
  • indexing / Indexing an hstore in PostgreSQL
• HAVING clause
  • about / HAVING clause
• Hibernate
  • overview / Hibernate overview and architecture
  • architecture / Hibernate overview and architecture
  • installation / Installation of Hibernate
  • URL / Installation of Hibernate
  • configuring / Configuring Hibernate
  • reference documentation , URL / Configuring Hibernate
  • Session, getting from SessionFactory / Getting a session from the SessionFactory
  • classes, mapping to tables / Mapping classes to tables
  • entity class, creating / Creating an entity class
  • mapping file, creating / Creating a mapping file
  • annotation-based mapping, using / Using annotation-based mapping
  • caching, using / Using caching
  • connection-pools, using / Using connection pools
  • partitioned tables / Dealing with partitioned tables
• high availability (HA) / Business advantages of PostgreSQL
• horizontal table partitioning / Table partitioning
• host_type, postgreSQL pg_hba.conf file
  • local / PostgreSQL pg_hba.conf
  • host / PostgreSQL pg_hba.conf
  • hostssl / PostgreSQL pg_hba.conf
  • hostnossl / PostgreSQL pg_hba.conf

I

• indexes
  • about / Indexes
  • types / Index types
  • partial index / Partial indexes
  • on expressions / Indexes on expressions
  • unique index / Unique indexes
  • multicolumn index / Multicolumn indexes
  • best practices / Best practices on indexes
• indexes, types
  • B-tree index / Index types
  • hash indexes / Index types
  • Generalized inverted index (GIN) / Index types
  • Generalized Search Tree (GiST) / Index types
  • Block range index (BRIN) / Index types
• INSERT statement
  • about / INSERT statement
• interfaces test
  • about / The interfaces test
  • data difference / Data difference
• International standard organization (ISO) / The SQL Language
• iteration
  • about / Iteration
  • Loop statement / The loop statement
  • While loop statement / The while loop statement
  • For loop statement / The for loop statement

J

• Java Database Connectivity (JDBC)
  • about / Introduction to JDBC
  • core components / Introduction to JDBC
  • URL / Installing the driver
  • design, considerations / Design considerations
• Java Naming and Directory Interface (JNDI) / Hibernate overview and architecture
• JavaScript Simple Object Notation (JSON) data type / NoSQL capabilities
• Java Transaction API (JTA) / Hibernate overview and architecture
• JSON datatype
  • about / The PostgreSQL JSON data type, The JSON data type
  • and XML / JSON and XML
  • modifying / Modifying and accessing JSON types
  • accessing / Modifying and accessing JSON types
  • indexing / Indexing a JSON data type
  • using, with PostgreSQL restful API / The PostgreSQL RESTful API with JSON

K

• key value store / Key value databases
• keywords / SQL lexical structure

L

• listen addresses / Listen addresses
• literals / SQL lexical structure
• locks, database
  • managing / Managing database locks
• Loop statement / The loop statement

M

• maintenance_work_mem function / Full text search indexing
• Management Group (OMG) / UML class diagrams
• materialized views / Materialized views
• memory settings
  • shared buffers (shared_buffers) / Memory settings
  • working memory (work_mem) / Memory settings
• mistakes, queries
  • about / Common mistakes in writing queries
  • unnecessary operations / Unnecessary operations
  • misplaced indexes / Misplaced indexes
  • unnecessary table / Unnecessary table or index scans
  • index scans / Unnecessary table or index scans
  • correlated nested queries, using / Using correlated nested queries
  • common table expressions (CTEs), using / Using CTE when not mandatory
  • plpgsql procedural language consideration, using / Using the PL/pgSQL procedural language consideration
• multiversion concurrency control (MVCC)
  • about / Transaction isolation and multiversion concurrency control

N

• Nagios plugin
  • URL / Getting ready
• NoSQL database / NoSQL motivation
• NoSQL databases
  • about / The NoSQL databases
  • CAP theorem / The CAP theorem
  • NoSQL motivation / NoSQL motivation
  • key value store / Key value databases
  • columnar databases / Columnar databases
  • document databases / Document databases
  • graph databases / Graph databases
• NULLS
  • about / Dealing with NULLs

O

• Object-relational database (ORD) / Relational and object relational databases
• Object-relational mapping (ORM)
  • about / Introduction to ORM and Hibernate
• object identifiers (OID) / The system catalog
• object size, database
  • obtaining / Getting the database and database object size, How to do it…, There's more…
• one-way encryption / One-way encryption
• Online analytical processing (OLAP) / PostgreSQL applications
• Online transactional processing (OLTP) / PostgreSQL applications
• Open Geospatial Consortium (OGC) / JSON and XML
• open source software (OSS) / Business advantages of PostgreSQL
• operators
  • URL / SQL lexical structure

P

• partial index / Partial indexes
• PgAdmin III / PgAdmin III
• pgcrypto extension
  • one-way data encryption / pgcrypto
  • two-way data encryption / pgcrypto
  • one-way data encryption / One-way encryption
  • two-way data encryption / Two-way encryption
• pgTAP
  • URL / Unit test frameworks
• pg_cancel_backend function / How it works…
• phenomena
  • about / Transaction isolation and multiversion concurrency control
• PL/pgSQL
  • about / Introduction
  • advantages / Introduction
  • and SQL language, comparing / SQL language and PL/pgSQL – a comparison
  • URL / SQL language and PL/pgSQL – a comparison
• PL/pgSQL control statements
  • about / The PostgreSQL PL/pgSQL control statements
  • declaration statement / Declaration statements
  • assignment statement / Assignment statements
  • conditional statements / Conditional statements
• Postgres-XC (extensible cluster) / Forks
• PostgreSQL
  • about / An overview of PostgreSQL
  • URL / An overview of PostgreSQL, Creating a function in the C language, Exception handling
  • history / PostgreSQL history
  • advantages / The advantages of PostgreSQL
  • business advantages / Business advantages of PostgreSQL
  • user advantages / PostgreSQL user advantages
  • applications / PostgreSQL applications
  • success stories / Success stories
  • forks / Forks
  • architecture / PostgreSQL architecture
  • abstract architecture / PostgreSQL abstract architecture
  • community / The PostgreSQL community
  • capabilities / PostgreSQL capabilities
  • installing / Installing PostgreSQL
  • installing, on Ubuntu / Installing PostgreSQL on Ubuntu
  • installing, on Windows / Installing PostgreSQL on Windows
  • documentation, URL / Psql advanced settings, SQL lexical structure
  • objects hierarchy / PostgreSQL objects hierarchy
  • template databases / Template databases
  • user databases / User databases
  • roles / Roles
  • tablespace / Tablespace
  • template procedural languages / Template procedural languages
  • settings / Settings
  • settings, parameter / Setting parameters
  • setting context / Setting a context
  • high level objects interaction / PostgreSQL high-level object interaction
  • maual, URL / Schema usages
  • authentication / Authentication in PostgreSQL
  • default access privileges / PostgreSQL default access privileges
  • security levels / PostgreSQL security levels
  • role password encryption / PostgreSQL role password encryption
  • system catalog / The system catalog
  • configuration, tuning / PostgreSQL configuration tuning
  • queries, tuning / Tuning PostgreSQL queries
  • arrays / PostgreSQL arrays
  • arrays, indexing / Indexing arrays in PostgreSQL
  • hash store (hstore) / Hash store
  • hash store (hstore), indexing / Indexing an hstore in PostgreSQL
  • JSON datatype / The PostgreSQL JSON data type
  • full text search / A PostgreSQL full text search
  • benchmark / PostgreSQL benchmarks
  • driver version, URL / Obtaining a connection
• PostgreSQL, capabilities
  • about / PostgreSQL capabilities
  • replication / Replication
  • security / Security
  • security, URL / Security
  • extension / Extension
  • NoSQL capabilities / NoSQL capabilities
  • foreign data wrapper / Foreign data wrapper
  • performance / Performance
  • SQL constructs / Very rich SQL constructs
• PostgreSQL, clients
  • about / The PostgreSQL clients
  • wrappers / The PostgreSQL clients
  • backup and replication / The PostgreSQL clients, Backup and replication
  • utilities / The PostgreSQL clients, Utilities
  • psql client / The psql client
  • PostgreSQL utility tools / PostgreSQL utility tools
  • PgAdmin III / PgAdmin III
• PostgreSQL, installing on Ubuntu
  • client installation / Client installation
  • server installation / Server installation
  • basic server configuration / Basic server configuration
• PostgreSQL, installing on Windows
  • about / Installing PostgreSQL on Windows
• PostgreSQL Build farm
  • URL / Installing PostgreSQL
• PostgreSQL configuration, tuning
  • about / PostgreSQL configuration tuning
  • maximum number of connections / Maximum number of connections
  • memory settings / Memory settings
  • hard disk settings / Hard disk settings
  • planner-related settings / Planner-related settings
  • benchmarking / Benchmarking is your friend
• PostgreSQL database
  • connecting to / Connecting to a PostgreSQL database
  • driver, installing / Installing the driver
  • driver, initializing / Initializing the driver
  • connection, obtaining / Obtaining a connection
  • error handling / Error handling
  • SQLWarnings / SQLWarnings
• PostgreSQL database, components
  • about / PostgreSQL database components
  • schema / Schema
  • schema, usages / Schema usages
  • table / Table
• PostgreSQL function parameters
  • about / PostgreSQL function parameters
  • authorization related parameters / Function authorization-related parameters
  • planner related parameters / Function planner-related parameters
  • configuration-related parameters / Function configuration-related parameters
• PostgreSQL functions
  • about / Functions
  • native programming languages / PostgreSQL native programming languages
  • creating, in C language / Creating a function in the C language
  • creating, in SQL language / Creating functions in the SQL language
  • creating, in PL/pgSQL language / Creating a function in the PL/pgSQL language
  • usages / PostgreSQL function usages
  • dependency / PostgreSQL function dependency
  • categories / PostgreSQL function categories
  • anonymous functions / PostgreSQL anonymous functions
• postgreSQL pg_hba.conf file
  • about / PostgreSQL pg_hba.conf
• PostgreSQL restful API
  • using, with JSON datatype / The PostgreSQL RESTful API with JSON
• PostgreSQL rule system / The PostgreSQL rule system
• PostgreSQL trigger system / The PostgreSQL trigger system
• PostgreSQL user-defined datatypes
  • about / PostgreSQL user-defined data types
  • PostgreSQL CREATE DOMAIN command / The PostgreSQL CREATE DOMAIN command
  • PostgreSQL CREATE TYPE command / The PostgreSQL CREATE TYPE command
• predefined variables
  • function / Function predefined variables
• PreparedStatements
  • about / PreparedStatements
• proxy authentication / Role system and proxy authentication
• psql client
  • about / The psql client
  • Psql advanced settings / Psql advanced settings

Q

• queries
  • writing, mistakes / Common mistakes in writing queries
• queries, tuning
  • about / Tuning PostgreSQL queries
  • EXPLAIN command / The EXPLAIN command and execution plan
  • execution plan / The EXPLAIN command and execution plan
  • plan issues, detecting / Detecting problems in query plans
• query
  • issuing / Issuing a query and processing the results
• query plans issues
  • detecting / Detecting problems in query plans
  • estimated row number / Detecting problems in query plans
  • in-memory operation / Detecting problems in query plans
  • in-disk sort operation / Detecting problems in query plans
  • buffer cache / Detecting problems in query plans

R

• relational algebra
  • about / Relational algebra
  • SELECT and PROJECT operations / The SELECT and PROJECT operations
  • RENAME operation / The RENAME operation
  • set theory operations / The Set theory operations
  • cross join operation / The CROSS JOIN (Cartesian product) operation
• relational and object relational databases
  • about / Relational and object relational databases
  • ACID properties / ACID properties
  • SQL language / The SQL Language
  • basic concepts / Basic concepts
  • relation schema / Relation
  • tuple / Tuple
  • attribute / Attribute
  • constraint / Constraint
• relkind attribute / The system catalog
• Rename operation / The RENAME operation
• replication
  • about / Replication
• reserved words
  • URL / The car web portal database
• results
  • limiting / Ordering and limiting the results
  • processing / Issuing a query and processing the results
• ResultSet
  • using / Using a ResultSet
  • navigating through / Navigating through a ResultSet, Navigating through a ResultSet
  • row data, reading / Reading row data
  • null values, handling / Handling null values
  • updateable / Scrollable and updateable ResultSets
  • scrollable / Scrollable and updateable ResultSets
  • data, changing / Changing the data in a ResultSet
  • getting, from function returning SETOF / Getting a ResultSet from a function returning SETOF
  • getting, from function returning refcursor / Getting a ResultSet from a function returning a refcursor
• roles, PostgreSQL
  • about / Roles
• role system, car portal
  • web_app user / Role system and proxy authentication
  • public_user group / Role system and proxy authentication
• row-level security / Row-level security
• rule systems
  • about / Triggers and rule systems
  • PostgreSQL rule system / The PostgreSQL rule system

S

• schema
  • differences / Schema difference
• schema, PostgreSQL database
  • about / Schema
  • usages / Schema usages
• schema security level / Schema security level
• SchemaSpy
  • URL / Documentation
• security levels
  • about / PostgreSQL security levels
  • database security level / Database security level
  • schema security level / Schema security level
  • table level security / Table-level security
  • column level security / Column-level security
  • row-level security / Row-level security
• Select-list
  • about / Select-list
  • SQL expressions / SQL expressions
  • DISTINCT / DISTINCT
• SELECT query
  • structure / The structure of the SELECT query
• SELECT statement
  • used, for querying data / Querying the data with the SELECT statement
• separation of concern (SoC) / Version control system
• set operations
  • UNION / Set operations – UNION, EXCEPT, and INTERSECT
  • EXCEPT / Set operations – UNION, EXCEPT, and INTERSECT
  • INTERSECT / Set operations – UNION, EXCEPT, and INTERSECT
• set theory operations / The Set theory operations
• special characters / SQL lexical structure
• SQL
  • about / SQL fundamentals
  • lexical structure / SQL lexical structure
• SQL keywords
  • URL / Database naming conventions
• SQL language
  • and PL/pgSQL, comparing / SQL language and PL/pgSQL – a comparison
• SQL statements / SQL lexical structure
• SQLWarnings / SQLWarnings
• statement / SQL lexical structure
• static statement
  • about / Static statements
• stored function
  • calling / Calling a stored function
  • ResultSet, getting / Getting a ResultSet from a stored function
• Structured Query Language (SQL) / The SQL Language
• subqueries
  • about / Subqueries
• system catalog
  • about / The system catalog

T

• table, PostgreSQL database
  • about / Table
  • native data types / PostgreSQL native data types
  • numeric types / Numeric types
  • character types / Character types
  • date and time types / Date and time types
  • car web portal database / The car web portal database
• table level security / Table-level security
• table partitioning
  • using / Table partitioning
  • vertical table partitioning / Table partitioning
  • horizontal table partitioning / Table partitioning
  • creating / Table partitioning
  • constraint exclusion limitations / Constraint exclusion limitations
• tablespace, PostgreSQL
  • about / Tablespace
• table structure
  • about / Getting information about the table structure
• template databases, PostgreSQL
  • about / Template databases
• template procedural languages, PostgreSQL
  • about / Template procedural languages
• The Oversized-Attribute Storage Technique (TOAST) / The system catalog
• Transaction Processing Performance Council (TPC) / Benchmarking is your friend
• transactions
  • about / Transaction isolation and multiversion concurrency control
• trigger system
  • PostgreSQL trigger system / The PostgreSQL trigger system
  • triggers, with arguments / Triggers with arguments
  • triggers, using to make views updatable / Using triggers to make views updatable
• TRUNCATE statement
  • about / TRUNCATE statement
• tsquery datatype / The tsquery data type
• tsvector datatype / The tsvector data type
• tuple / Tuple
• two-way encryption / Two-way encryption

U

• Ubuntu
  • PostgreSQL, installing on / Installing PostgreSQL on Ubuntu
• Unified modeling language (UML)
  • about / UML class diagrams
  • advantages / UML class diagrams
• uniform resource identifier (URI) / The PostgreSQL RESTful API with JSON
• unit testing
  • about / Unit testing
  • in databases / Unit testing in databases
  • frameworks / Unit test frameworks
• Universal unique identifiers (UUID) / Extension
• unnest function / Common functions of arrays and their operators
• updatable views / Updatable views
• UPDATE statement
  • about / UPDATE statement
  • sub-select, using / UPDATE using sub-select
  • additional tables, using / UPDATE using additional tables
• user databases, PostgreSQL
  • about / User databases
• user sessions
  • terminating / Terminating and canceling user sessions
  • cancelling / Terminating and canceling user sessions

V

• vertical table partitioning / Table partitioning
• views
  • about / Views
  • synopsis / View synopsis
  • categories / Views categories
  • materialized views / Materialized views
  • updatable views / Updatable views
• views, categories
  • temporary view / Views categories
  • recursive views / Views categories
  • updatable views / Views categories
  • materialized views / Views categories
• views dependency tree
  • obtaining / Getting the views dependency tree, Getting ready, How to do it…, There's more…

W

• WHERE clause
  • about / WHERE clause
  • comparison operators / Comparison operators
  • pattern matching / Pattern matching
  • row and array comparison constructs / Row and array comparison constructs
• While loop statement / The while loop statement
• window functions
  • about / Window functions
  • syntax / Window definition
  • WINDOW clause / The WINDOW clause
  • using / Using window functions
  • with grouping and aggregation / Window functions with grouping and aggregation

X

• XML
  • and JSON datatype / JSON and XML
• XML schema definition (XSD) / JSON and XML

Y

• yEd
  • URL / Documentation