Legal Notice
Table of Contents
About this book
Intended Audience
Book Contents
Conventions
Preface
What is EnterpriseDB?
Further Information
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. Performance Tips
III. The Superset Procedural Language
13. Programming in EDB-SPL
14. Triggers
IV. EDB Tools/Applications
15. EDB-Studio
16. EDB-PSQL+
17. EDB-Replication
V. Client Application Programming Interfaces
18. EDB Connector/Java
19. EDB Connector/.NET
20. EDB Connector/ODBC
VI. Database Server Administration
21. Server Run-time Environment
22. Database Users and Privileges
23. Managing Databases
24. Client Authentication
25. Localization
26. Routine Database Maintenance Tasks
27. Backup and Restore
28. Monitoring Database Activity
29. Monitoring Disk Usage
30. Write-Ahead Logging (WAL)
VII. Reference
I. SQL Commands
II. Database Utilities
III. Server Utilities
IV. EDB-Postgres System Catalogs
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
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 Pattern Modifiers for Date/Time Formatting
8-22. Template Patterns for Numeric Formatting
8-23. to_char and to_date function Examples
8-24. Date/Time Operators
8-25. Date/Time Functions
8-26. TRUNC format masks
8-27. Sequence Functions
8-28. Aggregate Functions
8-29. Series Generating Functions
8-30. Session Information Functions
8-31. Access Privilege Inquiry Functions
8-32. System Catalog Information Functions
8-33. Comment Information Functions
8-34. Configuration Settings Functions
8-35. Backend Signalling Functions
8-36. Backup Control Functions
9-1. Data Type Conversions for EDB/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
13-1. Parameter Modes
13-2. Cursor Attributes
16-1. EDB-PSQL+ Features
18-1. Connection Parameters
18-2. Additional Connection Properties
21-1. Short option key
21-2. System V IPC parameters
25-1. Server Character Sets
25-2. Client/Server Character Set Conversions
28-1. Standard Statistics Views
28-2. Statistics Access Functions
1. The System Catalogs
2. pg_aggregate Columns
3. pg_am Columns
4. pg_amop Columns
5. pg_amproc Columns
6. pg_attrdef Columns
7. pg_attribute Columns
8. pg_cast Columns
9. pg_class Columns
10. pg_constraint Columns
11. pg_conversion Columns
12. pg_database Columns
13. pg_depend Columns
14. pg_description Columns
15. pg_group Columns
16. pg_index Columns
17. pg_inherits Columns
18. pg_language Columns
19. pg_largeobject Columns
20. pg_listener Columns
21. pg_namespace Columns
22. pg_opclass Columns
23. pg_operator Columns
24. pg_proc Columns
25. pg_rewrite Columns
26. pg_shadow Columns
27. pg_statistic Columns
28. pg_tablespace Columns
29. pg_trigger Columns
30. pg_type Columns
31. System Views
32. pg_indexes Columns
33. pg_locks Columns
34. pg_rules Columns
35. pg_settings Columns
36. pg_stats Columns
37. pg_tables Columns
38. pg_user Columns
39. pg_views Columns
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
19-1. Opening a Database Connection via ASP.NET
19-2. Opening a Database Connection with a Console Based Application
19-3. Example - Retrieving all records from the dept table
19-4. Retrieving a Single Database Record
19-5. Example - Parameterized Queries
19-6. Example - Inserting a Database Record
19-7. Example - Deleting a Database Record
19-8. Example - Executing a simple Stored Procedure
19-9. Example - Executing a Stored Procedure with IN Parameters
19-10. Example - Executing a Stored Procedure with OUT Parameters (Method 1)
19-11. Example - Executing a Stored Procedure with OUT Parameters (Method 2)
19-12. Example - Executing a Stored Procedure with INOUT Parameters
24-1. An example pg_hba.conf file
24-2. An example pg_ident.conf file