Practical PostgreSQL

Type Book

Rate 0.0 /5

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 admi…

Details

Files

Reviews

Download

Title Statements

Full title :Practical PostgreSQL / John C. Worsley and Joshua D. Drake.

Summary

Edition Statements

Publication Date:2002.

Publication Statements

Publisher(s):O'Reilly
Place of Publication:Sebastopol, CA
Language:eng
Publication Date:2002.

The Physical Object

Description:1 online resource (xiv, 619 pages) : : illustrations

Edition Identifiers

ISBN:9781449310288, 1449310281, 9781449310103, 1449310109
oclc:ocn747033934
LC Classification:QA76.9.D3
Dewey Decimal:005.74

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 …

Subjects

Bases de données -- Gestion Computers -- Database Management COMPUTERS -- Desktop Applications COMPUTERS -- System Administration Database management Electronic books Logiciels libres Open source software PostgreSQL