UID:
edocfu_9961552805302883
Format:
1 online resource (638 p.)
Edition:
First edition.
ISBN:
1-4493-1010-9
,
1-4493-1028-1
Content:
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
Note:
"A hardened, robust, open source database"--Cover.
,
Includes index.
,
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
,
English
Additional Edition:
ISBN 1-4493-0977-1
Additional Edition:
ISBN 1-56592-846-6
Language:
English
Keywords:
Electronic books.
Bookmarklink