Acknowledgements Table of Contents About This Book Intended Audience Book Contents Conventions I. Tutorial 1. Getting Started 2. Advanced Concepts II. The SQL Language 3. SQL Syntax 4. Data Definition 5. Data Manipulation 6. Queries 7. Data Types 8. Functions and Operators 9. Type Conversion 10. Indexes 11. Concurrency Control 12. The Rule System 13. Performance Tips III. EnterpriseDB Superset Procedural Language 14. Programming in SPL 15. Triggers 16. Packages IV. EnterpriseDB Tools and Applications 17. EnterpriseDB Developer Studio 18. EnterpriseDB PSQL 19. EnterpriseDB PL Debugger 20. EnterpriseDB DBA Management Server 21. EnterpriseDB Replication 22. Browsing Oracle Databases 23. Migrating Oracle Databases to EnterpriseDB V. Client Application Programming Interfaces 24. EnterpriseDB JDBC Connector 25. EnterpriseDB .NET Connector 26. EnterpriseDB ODBC Connector 27. Using ADO with ODBC 28. ECPG - Embedded SQL in C 29. libpq - C Library VI. Database Server Administration 30. Server Run-time Environment 31. Database Roles and Privileges 32. Managing Databases 33. Client Authentication 34. Localization 35. Routine Database Maintenance Tasks 36. Backup and Restore 37. Monitoring Database Activity 38. Monitoring Disk Usage 39. Write-Ahead Logging (WAL) VII. Reference I. SQL Commands II. Database Utilities III. Server Utilities IV. EDB-Postgres System Catalogs V. EnterpriseDB Error Codes Index List of Tables 3-1. Operator Precedence (decreasing) 7-1. Data Types 7-2. Numeric Types 7-3. Character Types 7-4. Binary Large Object 7-5. BYTEA Literal Escaped Octets 7-6. BYTEA Output Escaped Octets 7-7. Date/Time Types 7-8. Date Input 7-9. Time Input 7-10. Special Date/Time Inputs 7-11. Date/Time Output Styles 7-12. Date Order Conventions 7-13. edb_redwood_date set to true 7-14. edb_redwood_date set to false 7-15. Boolean Type 8-1. Comparison Operators 8-2. Mathematical Operators 8-3. Mathematical Functions 8-4. Trigonometric Functions 8-5. SQL String Functions and Operators 8-6. Other String Functions 8-7. Built-in Conversions 8-8. SQL Binary String Functions and Operators 8-9. Other Binary String Functions 8-10. Regular Expression Match Operators 8-11. Regular Expression Atoms 8-12. Regular Expression Quantifiers 8-13. Regular Expression Constraints 8-14. Regular Expression Character-Entry Escapes 8-15. Regular Expression Class-Shorthand Escapes 8-16. Regular Expression Constraint Escapes 8-17. Regular Expression Back References 8-18. ARE Embedded-Option Letters 8-19. Formatting Functions 8-20. Template Date/Time Format Patterns for the to_char and to_date Functions 8-21. Template Date/Function Patterns for the round Function 8-22. Template Pattern Modifiers for Date/Time Formatting 8-23. Template Patterns for Numeric Formatting 8-24. to_char and to_date function Examples 8-25. Date/Time Operators 8-26. Date/Time Functions 8-27. TRUNC format masks 8-28. Sequence Functions 8-29. Aggregate Functions 8-30. Series Generating Functions 8-31. Session Information Functions 8-32. Access Privilege Inquiry Functions 8-33. System Catalog Information Functions 8-34. Comment Information Functions 8-35. Configuration Settings Functions 8-36. Backend Signalling Functions 8-37. Backup Control Functions 9-1. Data Type Conversions for SPL Assignment Statement 9-2. Data Type Conversions for Column Assignments 9-3. Data Type Conversions for Procedure and Function Calls 9-4. Data Type Conversions for Set Operations 11-1. SQL Transaction Isolation Levels 14-1. Parameter Modes 14-2. Cursor Attributes 14-3. Permitted Cursor Variable Parameter Modes 17-1. EnterpriseDB Server Registration Parameters 18-1. EnterpriseDB PSQL Features 20-1. Log file parameters 24-1. Connection Parameters 24-2. Additional Connection Properties 30-1. Short option key 30-2. System V IPC parameters 34-1. Server Character Sets 34-2. Client/Server Character Set Conversions 37-1. Standard Statistics Views 37-2. Statistics Access Functions 1. The System Catalogs 2. edb_package Columns 3. edb_pkgelements Columns 4. pg_aggregate Columns 5. pg_am Columns 6. pg_amop Columns 7. pg_amproc Columns 8. pg_attrdef Columns 9. pg_attribute Columns 10. pg_authid Columns 11. pg_auth_members Columns 12. pg_autovacuum Columns 13. pg_cast Columns 14. pg_class Columns 15. pg_constraint Columns 16. pg_conversion Columns 17. pg_database Columns 18. pg_depend Columns 19. pg_description Columns 20. pg_group Columns 21. pg_index Columns 22. pg_inherits Columns 23. pg_language Columns 24. pg_largeobject Columns 25. pg_listener Columns 26. pg_namespace Columns 27. pg_opclass Columns 28. pg_operator Columns 29. pg_pltemplate Columns 30. pg_proc Columns 31. pg_rewrite Columns 32. pg_shadow Columns 33. pg_shdepend Columns 34. pg_statistic Columns 35. pg_synonym Columns 36. pg_tablespace Columns 37. pg_trigger Columns 38. pg_type Columns 39. System Views 40. pg_indexes Columns 41. pg_locks Columns 42. pg_prepared_xacts Columns 43. pg_roles Columns 44. pg_rules Columns 45. pg_settings Columns 46. pg_stats Columns 47. pg_tables Columns 48. pg_user Columns 49. pg_views Columns 1. EnterpriseDB Error Codes List of Examples 7-1. Using the boolean type 10-1. Setting up a Partial Index to Exclude Common Values 10-2. Setting up a Partial Index to Exclude Uninteresting Values 10-3. Setting up a Partial Unique Index 25-1. Opening a Database Connection via ASP.NET 25-2. Opening a Database Connection with a Console Based Application 25-3. Example - Retrieving all records from the dept table 25-4. Retrieving a Single Database Record 25-5. Example - Parameterized Queries 25-6. Example - Inserting a Database Record 25-7. Example - Deleting a Database Record 25-8. Example - Executing a simple Stored Procedure 25-9. Example - Executing a Stored Procedure with IN Parameters 25-10. Example - Executing a Stored Procedure with OUT Parameters (Method 1) 25-11. Example - Executing a Stored Procedure with OUT Parameters (Method 2) 25-12. Example - Executing a Stored Procedure with INOUT Parameters 33-1. An example pg_hba.conf file 33-2. An example pg_ident.conf file     Next     About This Book
	©2004-2007 EnterpriseDB All Rights Reserved