Description |
1 online resource (xiv, 619 pages) : illustrations |
Summary |
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 running. This comprehensive book delves into the many advanced features of the PostgreSQL Application Server, LXP, including the the use of SQL within PostgreSQL, and covers basic PostgreSQL database administration. |
Contents |
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 |
Subject |
PostgreSQL.
|
|
PostgreSQL. |
|
PostgreSQL |
|
Database management.
|
|
Open source software.
|
|
Bases de données -- Gestion. |
|
Logiciels libres. |
|
Database management |
|
Open source software |
Added Author |
Drake, Joshua D.
|
Added Title |
Practical Postgres |
|
PostgreSQL |
|
Postgres |
Other Form: |
Print version: Worsley, John C. Practical PostgreSQL. Sebastopol, CA : O'Reilly & Associates, ©2002 1565928466 (DLC) 2002283901 (OCoLC)48846108 |
ISBN |
9781449310288 (electronic bk.) |
|
1449310281 (electronic bk.) |
|
9781449310103 (electronic bk.) |
|
1449310109 (electronic bk.) |
|
(pbk.) |
|
(pbk.) |
|