Summer Reading B2G1 Free
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    Lists | July 29, 2015

    Edward Carey: IMG 10 Best Books by Writer-Illustrators



    As a child who loved books I was fascinated by the illustrations just as much as the text. The same is true for me today, and I'm happy to be among... Continue »
    1. $11.89 Sale Hardcover add to wish list

      Foulsham (Iremonger Series #2)

      Edward Carey 9781468309546

    spacer
Qualifying orders ship free.
$10.50
Used Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Local Warehouse Database- Applications

Practical PostgreSQL with CDROM

by

Practical PostgreSQL with CDROM Cover

 

Synopses & Reviews

Publisher Comments:

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 covers the many advanced features, such as transactions, versioning, replication, and referential integrity that enable developers and DBAs to use PostgreSQL for serious business applications. The thorough introduction to PostgreSQL's PL/pgSQL programming language explains how you can use this very useful but under-documented feature to develop stored procedures and triggers. The book includes a complete command reference, and database administrators will appreciate the chapters on user management, database maintenance, and backup & recovery. With Practical PostgreSQL, you will discover quickly why this open source database is such a great open source alternative to proprietary products from Oracle, IBM, and Microsoft.Also included is a CD-ROM with Command Prompt's PostgreSQL ApplicationServer, LXP. The CD covers LXP version 0.8.0 and PostgreSQL version 7.1.3.

Book News Annotation:

This excellent introduction to what many regard as the most powerful open source database shows programmers, administrators and even the newly initiated how to successfully use PostgreSQL (pronounced "post- gres-cue-ell) as a backend database. Those new to PostgreSQL and database programming in general (though ideally with basic knowledge of Unix and relational database concepts) will find instructions for downloading and installing PostgreSQL (for Linux) from the CD-ROM included with the book, as well as an introduction to the SQL language and database queries. Those familiar with SQL can skip ahead to chapters which describe the server backend or postmaster process, how to connect to it using psql, operators and functions available to PostgreSQL, and advanced information about the psql client. Finally, parts three and four cover initializing, configuring, and managing databases; PL/pgSQL (PostgreSQL's native procedural language); the JDBC (Java Database Connectivity) interface; and the LXP web-based application server (an evaluation copy of which is included on the CD- ROM).
Annotation c. Book News, Inc., Portland, OR (booknews.com)

Synopsis:

A guide to installation, configuration and usage, this text also shows how to compile PostgreSQL from source, create a database and configure PostgreSQL to accept client-server connections, as well as delving into the application's many advanced features.

Synopsis:

Complete with a CD-ROM of the PostgreSQL Application Server, LXP, this comprehensive new volume shows USERS how to compile PostgreSQL from source, create a database, and configure PostgreSQL to accept client-server connections. It also covers the many advanced features, such as transactions, versioning, replication, and referential integrity that enable developers and DBAs to use PostgreSQL for serious business applications.

Table of Contents

Preface; Who Is the Intended Audience?; Structure of This Book; Platform and Version Used; What Is Included on the CD?; Conventions Used in This Book; Acknowledgments; Comments and Questions; Introduction and Installation; Chapter 1: What Is PostgreSQL?; 1.1 Open Source Free Version; 1.2 PostgreSQL Feature Set; 1.3 Where to Proceed from Here; Chapter 2: Installing PostgreSQL; 2.1 Preparing for Installation; 2.2 10 Steps to Installing PostgreSQL; Using PostgreSQL; Chapter 3: Understanding SQL; 3.1 Introduction to SQL; 3.2 Introduction to Relational Databases; 3.3 SQL Statements; 3.4 Data Types; 3.5 Tables in PostgreSQL; Chapter 4: Using SQL with PostgreSQL; 4.1 Introduction to psql; 4.2 Using Tables; 4.3 Adding Data with INSERT and COPY; 4.4 Retrieving Rows with SELECT; 4.5 Modifying Rows with UPDATE; 4.6 Removing Rows with DELETE; 4.7 Using Sub-Queries; 4.8 Using Views; 4.9 Further SQL Application; Chapter 5: Operators and Functions; 5.1 Operators; 5.2 Functions; Chapter 6: PostgreSQL Clients; 6.1 The psql Client: Advanced Topics; 6.2 PgAccess: A Graphical Client; Chapter 7: Advanced Features; 7.1 Indices; 7.2 Advanced Table Techniques; 7.3 Arrays; 7.4 Automating Common Routines; 7.5 Transactions and Cursors; 7.6 Extending PostgreSQL; Administrating PostgreSQL; Chapter 8: Authentication and Encryption; 8.1 Client Authentication; 8.2 Encrypting Sessions; Chapter 9: Database Management; 9.1 Starting and Stopping PostgreSQL; 9.2 Initializing the Filesystem; 9.3 Creating and Removing a Database; 9.4 Maintaining a Database; 9.5 Backing Up and Restoring Data; Chapter 10: User and Group Management; 10.1 Managing Users; 10.2 Managing Groups; 10.3 Granting Privileges; PostgreSQL Programming; Chapter 11: PL/pgSQL; 11.1 Adding PL/pgSQL to Your Database; 11.2 Language Structure; 11.3 Using Variables; 11.4 Controlling Program Flow; 11.5 PL/pgSQL and Triggers; Chapter 12: JDBC; 12.1 Building the PostgreSQL JDBC Driver; 12.2 Using the PostgreSQL Driver; 12.3 Using JDBC; 12.4 Issues Specific to PostgreSQL and JDBC; Chapter 13: LXP; 13.1 Why Use LXP?; 13.2 Core Features; 13.3 Installing and Configuring LXP; 13.4 Understanding LXP Mark-Up; 13.5 LXP Variables and Objects; 13.6 Using Cookies with LXP; 13.7 Tag Parsing; 13.8 Branching Logic; 13.9 Loop Iteration; 13.10 Content Inclusion; 13.11 Displaying Foreign Tags with ; Command Reference; Chapter 14: PostgreSQL Command Reference; 14.1 Abort; 14.2 Alter Group; 14.3 Alter Table; 14.4 Alter User; 14.5 Begin; 14.6 Close; 14.7 Cluster; 14.8 Comment; 14.9 Commit; 14.10 Copy; 14.11 Create Aggregate; 14.12 Create Database; 14.13 Create Function; 14.14 Create Group; 14.15 Create Index; 14.16 Create Language; 14.17 Create Operator; 14.18 Create Rule; 14.19 Create Sequence; 14.20 Create Table; 14.21 Create Table As; 14.22 Create Trigger; 14.23 Create Type; 14.24 Create User; 14.25 Create View; 14.26 Current_Date; 14.27 Current_Time; 14.28 Current_Timestamp; 14.29 Current_User; 14.30 Declare; 14.31 Delete; 14.32 Drop Aggregate; 14.33 Drop Database; 14.34 Drop Function; 14.35 Drop Group; 14.36 Drop Index; 14.37 Drop Language; 14.38 Drop Operator; 14.39 Drop Rule; 14.40 Drop Sequence; 14.41 Drop Table; 14.42 Drop Trigger; 14.43 Drop Type; 14.44 Drop User; 14.45 DROP VIEW; 14.46 End; 14.47 Explain; 14.48 FETCH; 14.49 Grant; 14.50 Insert; 14.51 Listen; 14.52 Load; 14.53 Lock; 14.54 Move; 14.55 Notify; 14.56 Reindex; 14.57 Reset; 14.58 Revoke; 14.59 Rollback; 14.60 Select; 14.61 Select Into; 14.62 Set; 14.63 Set Constraints; 14.64 Set Transaction; 14.65 Show; 14.66 Truncate; 14.67 Unlisten; 14.68 Update; 14.69 Vacuum; Multibyte Encoding Types; Backend Options for postgres; Binary COPY Format; The Header; Tuples; Trailer; Internal psql Variables; About the Authors; Colophon;

Product Details

ISBN:
9781565928466
Author:
Worsley, John C.
Author:
Drake, Joshua D.
Author:
Drake, Joshua
Author:
Worsley, John C.
Author:
Drake, Joshua D.
Publisher:
O'Reilly Media
Location:
Sebastopol, CA
Subject:
Programming Languages - General
Subject:
Programming Languages - SQL
Subject:
Database Management - General
Subject:
Database management
Subject:
PostgreSQL
Subject:
DBAs;PostgreSQL;object-relational;open source databases
Subject:
Database design
Subject:
CourseSmart Subject Description
Copyright:
Edition Description:
Print PDF
Series Volume:
6709.11
Publication Date:
20020117
Binding:
Paperback
Language:
English
Illustrations:
Yes
Pages:
640
Dimensions:
23 cm. +

Other books you might like

  1. PostgreSQL: Introduction and Concepts Used Trade Paper $7.50
  2. Windows XP in a Nutshell Used Trade Paper $1.25
  3. Php and Postgresql Advanced Web... Used Trade Paper $25.00

Related Subjects

» Computers and Internet » Computer Languages » SQL
» Computers and Internet » Database » Applications
» Computers and Internet » Database » Design
» Computers and Internet » Database » SQL
» Computers and Internet » Software Engineering » Software Management
» History and Social Science » Politics » General

Practical PostgreSQL with CDROM Used Trade Paper
0 stars - 0 reviews
$10.50 In Stock
Product details 640 pages O'Reilly Media - English 9781565928466 Reviews:
"Synopsis" by , A guide to installation, configuration and usage, this text also shows how to compile PostgreSQL from source, create a database and configure PostgreSQL to accept client-server connections, as well as delving into the application's many advanced features.
"Synopsis" by ,
Complete with a CD-ROM of the PostgreSQL Application Server, LXP, this comprehensive new volume shows USERS how to compile PostgreSQL from source, create a database, and configure PostgreSQL to accept client-server connections. It also covers the many advanced features, such as transactions, versioning, replication, and referential integrity that enable developers and DBAs to use PostgreSQL for serious business applications.
spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.