Practical PostgreSQL / John C. Worsley and Joshua D. Drake.

Format:

Book

Author/Creator:

Worsley, John C. (John Clayton), 1978-

Contributor:

Drake, Joshua D.

Language:

English

Subjects (All):

PostgreSQL.

Database management.

Open source software.

Genre:

Electronic books.

Physical Description:

1 online resource (638 p.)

Edition:

First edition.

Other Title:

Practical Postgres

PostgreSQL

Postgres

Place of Publication:

2012.

Beijing ; Sebastopol, California : O'Reilly, 2002.

Language Note:

English

System Details:

text file

Summary:

Arguably the most capable of all the open source databases, PostgreSQL is an object-relational database management system first developed in 1977 by the University of California at Berkeley. In spite of its long history, this robust database suffers from a lack of easy-to-use documentation. Practical PostgreSQL fills that void with a fast-paced guide to installation, configuration, and usage. This comprehensive new volume shows you how to compile PostgreSQL from source, create a database, and configure PostgreSQL to accept client-server connections. It also cover

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

Notes:

"A hardened, robust, open source database"--Cover.

Includes index.

Description based on online resource; title from PDF title page (ebrary, viewed October 9, 2013).

ISBN:

9781449310103

1449310109

9781449310288

1449310281

OCLC:

780425545