Flylib.com
PostgreSQL(c) The comprehensive guide to building, programming, and administering PostgreSQL databases
ISBN: 735712573
EAN: N/A
Year: 2004
Pages: 261
BUY ON AMAZON
Part I: General PostgreSQL Use
Introduction to PostgreSQL and SQL
Introduction to PostgreSQL and SQL
A Sample Database
Basic Database Terminology
Prerequisites
Connecting to a Database
Creating Tables
Viewing Table Descriptions
Adding New Records to a Table
Installing the Sample Database
Retrieving Data from the Sample Database
The CASE Expression
Aggregates
Multi-Table Joins
UPDATE
DELETE
A (Very) Short Introduction to Transaction Processing
Creating New Tables Using CREATE TABLE...AS
Using VIEW
Summary
Working with Data in PostgreSQL
Working with Data in PostgreSQL
NULL Values
Character Values
Numeric Values
Date/Time Values
Boolean (Logical) Values
Geometric Data Types
Object IDs (OID)
BLOBs
Network Address Data Types
Sequences
Arrays
Column Constraints
Expression Evaluation and Type Conversion
Creating Your Own Data Types
Summary
PostgreSQL SQL Syntax and Use
PostgreSQL SQL Syntax and Use
PostgreSQL Naming Rules
Creating, Destroying, and Viewing Databases
Creating New Tables
Adding Indexes to a Table
Getting Information About Databases and Tables
Transaction Processing
Summary
Performance
Performance
How PostgreSQL Organizes Data
Gathering Performance Information
Understanding How PostgreSQL Executes a Query
Execution Plans Generated by the Planner
The ARC Buffer Manager
Table Statistics
Performance Tips
Part II: Programming with PostgreSQL
Introduction to PostgreSQL Programming
Introduction to PostgreSQL Programming
Server-Side Programming
Client-Side APIs
General Structure of Client Applications
Choosing an Application Environment
Summary
Extending PostgreSQL
Extending PostgreSQL
Extending the PostgreSQL Server with Custom Functions
Returning Multiple Values from an Extension Function
The PostgreSQL SRF Interface
Returning Complete Rows from an Extension Function
Extending the PostgreSQL Server with Custom Data Types
Internal and External Forms
Defining a Simple Data Type in PostgreSQL
Defining the Data Type in C
Defining the Input and Output Functions in C
Defining the Input and Output Functions in PostgreSQL
Defining the Data Type in PostgreSQL
Indexing Custom Data Types
Summary
PL/pgSQL
PL/pgSQL
Installing PL/pgSQL
Language Structure
Function Body
Cursors
Triggers
Polymorphic Functions
PL/pgSQL and Security
Summary
The PostgreSQL C APIlibpq
The PostgreSQL C APIlibpq
Prerequisites
Client 1Connecting to the Server
Client 2Adding Error Checking
Client 3Simple ProcessingPQexec() and PQprint()
Client 4An Interactive Query Processor
Summary
A Simpler C APIlibpgeasy
A Simpler C APIlibpgeasy
Prerequisites
Client 1Connecting to the Server
Client 2Adding Error Checking
Client 3Processing Queries
Client 4An Interactive Query Processor
Summary
The New PostgreSQL C++ APIlibpqxx
The New PostgreSQL C++ APIlibpqxx
Prerequisites
Client 1Connecting to the Server
Client 2Adding Error Checking
Client 3Processing Queries
Client 4Working with transactors
Summary
Embedding SQL Commands in C Programsecpg
Embedding SQL Commands in C Programsecpg
Prerequisites
Client 1Connecting to the Server
Client 2Adding Error Checking
Client 3Processing SQL Commands
Client 4An Interactive Query Processor
Summary
Using PostgreSQL from an ODBC Client Application
Using PostgreSQL from an ODBC Client Application
ODBC Architecture Overview
Prerequisites
Client 1Connecting to the Server
Client 2Adding Error Checking
Client 3Processing Queries
Client 4An Interactive Query Processor
Summary
Resources
Using PostgreSQL from a Java Client Application
Using PostgreSQL from a Java Client Application
JDBC Architecture Overview
Prerequisites
Client 1Connecting to the Server
Client 2Adding Error Checking
Client 3Processing Queries
Client 4An Interactive Query Processor
Summary
Using PostgreSQL with Perl
Using PostgreSQL with Perl
DBI Architecture Overview
Prerequisites
Client 1Connecting to the Server
Client 2Adding Error Checking
Client 3Processing Queries
Client 4An Interactive Query Processor
Summary
Using PostgreSQL with PHP
Using PostgreSQL with PHP
PHP Architecture Overview
Prerequisites
Client 1Connecting to the Server
Client 2Adding Error Checking
Client 3Query Processing
Client 4An Interactive Query Processor
Other Features
Summary
Using PostgreSQL with Tcl and Tcl/Tk
Using PostgreSQL with Tcl and Tcl/Tk
Prerequisites
Client 1Connecting to the Server
Client 2Query Processing
Client 3An Interactive Query Processor
The libpgtcl Large-Object API
Summary
Using PostgreSQL with Python
Using PostgreSQL with Python
Python/PostgreSQL Interface Architecture
Prerequisites
Client 1Connecting to the Server
Client 2Adding Error Checking
Client 3Query Processing
Client 4An Interactive Command Processor
Summary
Npgsql: The .NET Data Provider
Npgsql: The .NET Data Provider
Prerequisites
Preparing Visual Studio
Understanding the ADO.NET Class Hierarchy
Creating an Npgsql-enabled VB Project
Client 1Connecting to the Server
Client 2An Interactive Query Processor
Client 3Updating the Database with a DataSet
Client 4A More Robust Query Processor
Client 5Using a Typed DataSet
Summary
Other Useful Programming Tools
Other Useful Programming Tools
PL/JavaWriting Stored Procedures in Java
pgcurlWeb-enabling Your PostgreSQL Server
pgbashWriting PostgreSQL-enabled Shell Scripts
Part III: PostgreSQL Administration
Introduction to PostgreSQL Administration
Introduction to PostgreSQL Administration
Security
User Accounts
Backup and Restore
Server Startup and Shutdown
Running PostgreSQL on a Windows Host
Tuning
Installing Updates
Localization
Summary
PostgreSQL Administration
PostgreSQL Administration
Roadmap (Wheres All My Stuff?)
Installing PostgreSQL
Managing Databases
The PostgreSQL BGWRITER process
Managing User Accounts
Configuring Your PostgreSQL Runtime Environment
Arranging for PostgreSQL Startup and Shutdown
Backing Up and Copying Databases
Point-in-time Recovery
Summary
Internationalization and Localization
Internationalization and Localization
Locale Support
Summary
Security
Security
Securing the PostgreSQL Data Files
Securing Network Access
Securing Tables
Securing Functions
Summary
Replicating PostgreSQL Data with Slony
Replicating PostgreSQL Data with Slony
Overview
Requirements
Creating a Replication Cluster
Starting the Replication Daemons
Creating a Replication Set
Subscribing to a Replication Set
Changing the Cluster Topology (Re-mastering and Failover)
Summary
Contributed Modules
Contributed Modules
Exchanging PostgreSQL Data with XML
Using Full-text Search
Index
PostgreSQL(c) The comprehensive guide to building, programming, and administering PostgreSQL databases
ISBN: 735712573
EAN: N/A
Year: 2004
Pages: 261
BUY ON AMAZON
Absolute Beginner[ap]s Guide to Project Management
The Goals, Objectives, and Principles of Project Issue Management
What Are Project Communications?
Value of Reviewing Stakeholder Expectation Management
Managing Differences
Twelve Tips for Buyers
Secure Programming Cookbook for C and C++: Recipes for Cryptography, Authentication, Input Validation & More
Building a Static Library from the Command Line
Building A Simple Hello, World Application with GNU make
Causing a Source File to Be Linked Automatically Against a Specified Library
Combining Two Paths into a Single Path
Implementing a Stride Iterator
Competency-Based Human Resource Management
Why a Focus on Jobs Is Not Enough
Competency-Based Employee Rewards
Competency-Based Employee Development
Appendix B Further Suggestions on Employee Development
Appendix C Examples of Life-Career Assessment Exercises
Wireless Hacks: Tips & Tools for Building, Extending, and Securing Your Network
Hack 12. Send SMS from Linux
Hack 26. Find and Join Wireless Networks with AP Radar
Hack 53. Do-It-Yourself Access Point Hardware
Hack 79. Advertise Any Service with Bonjour in Mac OS X
Hack 81. Use a Windows-Only Wireless Card in Linux
Microsoft WSH and VBScript Programming for the Absolute Beginner
Getting Started with the WSH and VBScript
Overview of the Windows Script Host
VBScript Basics
Combining Different Scripting Languages
Appendix A WSH Administrative Scripting
Understanding Digital Signal Processing (2nd Edition)
DISCRETE LINEAR SYSTEMS
THE DFT FREQUENCY RESPONSE TO A REAL COSINE INPUT
BANDPASS QUADRATURE SIGNALS IN THE FREQUENCY DOMAIN
FREQUENCY DEMODULATION ALGORITHMS
REFERENCES
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies