Cargando…
Practical PostgreSQL /
Arguably the most capable of all the open source databases, PostgreSQL is an object-relational database management system that--until now--lacked comprehensive, easy-to-use documentation. Practical PostgreSQL is a fast-paced guide that shows you how to get PostgreSQL installed, configured, and runni...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Otros Autores: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Sebastopol, CA :
O'Reilly,
2002.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- Copyright; Table of Contents; Preface; I: Introduction & Installation; 1: What Is PostgreSQL?; Open Source Free Version; PostgreSQL Feature Set; Where to Proceed from Here; 2: Installing PostgreSQL; Preparing for Installation; 10 Steps to Installing PostgreSQL; II: Using PostgreSQL; 3: Understanding SQL; Introduction to SQL; Introduction to Relational Databases; SQL Statements; Data Types; Tables in PostgreSQL; 4: Using SQL with PostgreSQL; Introduction to psql; Using Tables; Adding Data with INSERT and COPY; Retrieving Rows with SELECT; Modifying Rows with UPDATE; Removing Rows with DELETE
- Using Sub-QueriesUsing Views; Further SQL Application; 5: Operators and Functions; Operators; Functions; 6: PostgreSQL Clients; The psql Client: Advanced Topics; PgAccess: A Graphical Client; 7: Advanced Features; Indices; Advanced Table Techniques; Arrays; Automating Common Routines; Transactions and Cursors; Extending PostgreSQL; III: Administrating PostgreSQL; 8: Authentication and Encryption; Client Authentication; Encrypting Sessions; 9: Database Management; Starting and Stopping PostgreSQL; Initializing the Filesystem; Creating and Removing a Database; Maintaining a Database
- Backing Up and Restoring Data10: User and Group Management; Managing Users; Managing Groups; Granting Privileges; IV: PostgreSQL Programming; 11: PL/pgSQL; Adding PL/pgSQL to Your Database; Language Structure; Using Variables; Controlling Program Flow; PL/pgSQL and Triggers; 12: JDBC; Building the PostgreSQL JDBC Driver; Using the PostgreSQL Driver; Using JDBC; Issues Specific to PostgreSQL and JDBC; 13: LXP; Why Use LXP?; Core Features; Installing and Configuring LXP; Understanding LXP Mark-Up; LXP Variables and Objects; Using Cookies with LXP; Tag Parsing; Branching Logic; Loop Iteration
- Content InclusionDisplaying Foreign Tags with ; V: Command Reference; 14: PostgreSQL Command Reference; A: Multibyte Encoding Types; B: Backend Options for postgres; C: Binary COPY Format; D: Internal psql Variables; Index; About the Authors; Colophon