PostgreSQL developer's guide : design, develop, and implement streamlined databases with postgreSQL /
Annotation
Clasificación: | Libro Electrónico |
---|---|
Autores principales: | , , |
Otros Autores: | , , , |
Formato: | Electrónico eBook |
Idioma: | Inglés |
Publicado: |
Birmingham, England ; Mumbai [India] :
Packt Publishing,
2015.
|
Colección: | Community experience distilled.
|
Temas: | |
Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Getting Started with PostgreSQL; Writing queries using psql; Creating, altering, and truncating a table; Creating tables; Altering tables; Truncating tables; Inserting, updating, and deleting data from tables; Inserting data; Updating data; Deleting data; PostgreSQL's supported data types; PostgreSQL's operators and usage; Logical operators; Comparison operators; Mathematical operators; Constraints in PostgreSQL; Unique constraints; Not-null constraints
- Exclusion constraintsPrimary key constraints; Foreign key constraints; Check constraints; Privileges in PostgreSQL; Summary; Chapter 2: The Procedural Language; Why should you use PL/pgSQL?; Installing PL/pgSQL; Understanding the structure of PL/pgSQL; Using comments in PL/pgSQL; Declaring variables in PL/pgSQL; Declaring function parameters; Declaring the %TYPE attribute; Declaring the row-type and record type variables; Statements and expressions; Using statements; The assignment statement; Function call/return from a function; The RETURN expression; Exception handling statements
- Compound statementsExpressions; Control structures; Conditional statements; IF-THEN; IF-THEN-ELSE; IF-THEN-ELSIF; Simple CASE; Searched CASE; Loops; The simple loop; The WHILE loop; The FOR loop; Exception handling; Native support for other procedural languages; PL/Python; Installing PL/Python; Writing functions in PL/Python; Handling arguments with PL/Python; Accessing the database with PL/Python; PL/Perl; Installing PL/Perl; Writing functions in PL/Perl; Handling arguments with PL/Perl; Accessing the database with PL/Perl; PL/Tcl; Installing PL/Tcl; Writing functions in PL/Tcl
- Handling arguments with PL/TclAccessing the database with PL/Tcl; Summary; Chapter 3: Working with Indexes; What is an index?; How to create an index; How to drop an index; Types of indexes; The single-column index; The multicolumn index; The partial index; The unique index; Explicitly creating an index using the CREATE INDEX command; The expression index; The implicit index; The concurrent index; Index types; The B-tree index; The hash index; The GiST index; The GIN index; Index bloating; Dump and restore; VACUUM; CLUSTER; Reindexing; Points to ponder; Summary
- Chapter 4: Triggers, Rules, and ViewsUnderstanding triggers; Tricky triggers; Creating triggers and trigger functions with PL/pgSQL; Creating triggers on views; Creating triggers in PL/Perl; Creating triggers in PL/Tcl; Creating triggers in PL/Python; PostgreSQL rules; Rules versus triggers
- creating updateable views with rules; Understanding views; Materialized views; Creating materialized views; Summary; Chapter 5: Window Functions; Understanding window functions; The cume_dist() function; The row_number() function; The rank() function; The dense_rank() function