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. General-Purpose Aggregate Functions
8-30. Aggregate Functions for Statistics
8-31. Series Generating Functions
8-32. Session Information Functions
8-33. Access Privilege Inquiry Functions
8-34. System Catalog Information Functions
8-35. Comment Information Functions
8-36. Configuration Settings Functions
8-37. Backend Signalling Functions
8-38. Backup Control Functions
8-39. Advisory Lock 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
28-1. Valid input formats for PGTYPESdate_from_asc
28-2. Valid input formats for PGTYPESdate_fmt_asc
28-3. Valid input formats for rdefmtdate
28-4. Valid input formats for PGTYPEStimestamp_from_asc
30-1. Short option key
30-2. System V IPC parameters
34-1. EnterpriseDB Character Sets
34-2. Client/Server Character Set Conversions
37-1. Standard Statistics Views
37-2. Statistics Access Functions
1-1. System Catalogs
1-2. pg_aggregate Columns
1-3. pg_am Columns
1-4. pg_amop Columns
1-5. pg_amproc Columns
1-6. pg_attrdef Columns
1-7. pg_attribute Columns
1-8. pg_authid Columns
1-9. pg_auth_members Columns
1-10. pg_autovacuum Columns
1-11. pg_cast Columns
1-12. pg_class Columns
1-13. pg_constraint Columns
1-14. pg_conversion Columns
1-15. pg_database Columns
1-16. pg_depend Columns
1-17. pg_description Columns
1-18. pg_index Columns
1-19. pg_inherits Columns
1-20. pg_language Columns
1-21. pg_largeobject Columns
1-22. pg_listener Columns
1-23. pg_namespace Columns
1-24. pg_opclass Columns
1-25. pg_operator Columns
1-26. pg_pltemplate Columns
1-27. pg_proc Columns
1-28. pg_rewrite Columns
1-29. pg_shdepend Columns
1-30. pg_shdescription Columns
1-31. pg_statistic Columns
1-32. pg_tablespace Columns
1-33. pg_trigger Columns
1-34. pg_type Columns
1-35. System Views
1-36. pg_cursors Columns
1-37. pg_group Columns
1-38. pg_indexes Columns
1-39. pg_locks Columns
1-40. pg_prepared_statements Columns
1-41. pg_prepared_xacts Columns
1-42. pg_roles Columns
1-43. pg_rules Columns
1-44. pg_settings Columns
1-45. pg_shadow Columns
1-46. pg_stats Columns
1-47. pg_tables Columns
1-48. pg_timezone_abbrevs Columns
1-49. pg_timezone_names Columns
1-50. pg_user Columns
1-51. pg_views Columns
1. EnterpriseDB Error Codes