Cargando…
PostgreSQL 11 Server Side Programming Quick Start Guide : Effective Database Programming and Interaction.
PostgreSQL is a rock-solid, scalable, and safe, enterprise-level relational database. With a broad range of features and stability it is ever increasing in popularity. The book shows you how to take advantages of PostgreSQL 11 features for Server-Side-Programming. Server-Side-Programming enables str...
| Autor principal: | |
|---|---|
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Publishing Ltd,
2018.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Cover; Title Page; Copyright and Credits; Dedication; About Packt; Contributors; Table of Contents; Preface; Chapter 1: PostgreSQL Server-side Programming; What is server-side programming?; How to get help; The example database; The source code of the examples in this book; Summary; Chapter 2: Statement Tricks: UPSERTs, RETURNING, and CTEs; Inserting, updating, or both?; Getting back modified data with RETURNING; Common Table Expressions (CTEs); Introducing CTEs; Writable CTEs and the RETURNING clause: Pipelining statements; Recursive CTEs; Summary; References
- Chapter 3: The PL/pgSQL LanguageAn introduction to PL/pgSQL; Variables and variable assignment; Conditionals; Iterations; Exceptions and error handling; The RAISE statement revisited; Executing dynamic statements; Throwing away a query result set; The FOUND Global Variable; Summary; References; Chapter 4: Stored Procedures; Using functions, procedures, and routines; Supported languages; Functions; Return Types; Function argument list; Returning values to the caller; Security; Immutability; Costs; Moving functions to other schemas; Temporary functions; Where is my function?; Permissions
- A tag insertion functionCompile and runtime problem detection; Procedures; Procedure argument list; Returning values to the caller; Security; Permissions; Moving procedures to other schemas; Temporary procedures; Where is my procedure?; Interacting with transactions; Nesting transactions and procedures; Summary; References; Chapter 5: PL/Perl and PL/Java; PL/Perl; Database interaction; Function arguments and return types; Re-implementing functions in PL/Perl; Implementing routines in PL/Perl; PL/Java; Installing PL/Java; PL/Java main concepts
- Implementing a PL/Java function without a deployment descriptorImplementing a PL/Java function with a deployment descriptor; Summary; References; Chapter 6: Triggers; Data manipulation triggers; The trigger function; Creating a simple trigger; Discovering if a table has triggers; Disabling Triggers; Using triggers to modify data on the fly; Parametric triggers; Aborting the current statement; The WHEN condition; The REFERENCING clause; Using a trigger to perform multiple statements; Trigger examples in foreign languages; PL/Perl Triggers; PL/Java Triggers; Data definition triggers
- The trigger functionA first event trigger; Using event triggers to avoid specific commands; Filtering specific commands; Managing event triggers; Event trigger examples in foreign languages; PL/Perl; PL/Java; Summary; References; Chapter 7: Rules and the Query Rewriting System; Introducing the query rewriting system; What is the query rewriting system?; When and where are rules used by PostgreSQL?; Rules; The syntax of rules; A rule example
- archiving tuples on deletion; Where is my rule?; Conditional rules; Using a rule to execute multiple statements- the playlist example