6. Client Interfaces
This part describes the client programming interfaces distributed with PostgreSQL. Each of these chapters can be read independently. Note that there are many other programming interfaces for client programs that are distributed separately and contain their own documentation (external-projects lists some of the more popular ones). Readers of this part should be familiar with using SQL commands to manipulate and query the database (see sql) and of course with the programming language that the interface uses.
- 6.1. libpq — C Library
- 6.1.1. Database Connection Control Functions
- 6.1.2. Connection Status Functions
- 6.1.3. Command Execution Functions
- 6.1.4. Asynchronous Command Processing
- 6.1.5. Pipeline Mode
- 6.1.6. Retrieving Query Results Row-by-Row
- 6.1.7. Canceling Queries in Progress
- 6.1.8. The Fast-Path Interface
- 6.1.9. Asynchronous Notification
- 6.1.10. Functions Associated with the COPY Command
- 6.1.11. Control Functions
- 6.1.12. Miscellaneous Functions
- 6.1.13. Notice Processing
- 6.1.14. Event System
- 6.1.15. Environment Variables
- 6.1.16. The Password File
- 6.1.17. The Connection Service File
- 6.1.18. LDAP Lookup of Connection Parameters
- 6.1.19. SSL Support
- 6.1.20. Behavior in Threaded Programs
- 6.1.21. Building libpq Programs
- 6.1.22. Example Programs
- 6.2. Large Objects
- 6.2.1. Introduction
- 6.2.2. Implementation Features
- 6.2.3. Client Interfaces
- 6.2.3.1. Creating a Large Object
- 6.2.3.2. Importing a Large Object
- 6.2.3.3. Exporting a Large Object
- 6.2.3.4. Opening an Existing Large Object
- 6.2.3.5. Writing Data to a Large Object
- 6.2.3.6. Reading Data from a Large Object
- 6.2.3.7. Seeking in a Large Object
- 6.2.3.8. Obtaining the Seek Position of a Large Object
- 6.2.3.9. Truncating a Large Object
- 6.2.3.10. Closing a Large Object Descriptor
- 6.2.3.11. Removing a Large Object
- 6.2.4. Server-Side Functions
- 6.2.5. Example Program
- 6.3. ECPG — Embedded SQL in C
- 6.3.1. The Concept
- 6.3.2. Managing Database Connections
- 6.3.3. Running SQL Commands
- 6.3.4. Using Host Variables
- 6.3.5. Dynamic SQL
- 6.3.6. pgtypes Library
- 6.3.7. Using Descriptor Areas
- 6.3.8. Error Handling
- 6.3.9. Preprocessor Directives
- 6.3.10. Processing Embedded SQL Programs
- 6.3.11. Library Functions
- 6.3.12. Large Objects
- 6.3.13. C++ Applications
- 6.3.14. Embedded SQL Commands
- 6.3.15. Description
- 6.3.16. Parameters
- 6.3.17. Examples
- 6.3.18. Compatibility
- 6.3.19. See Also
- 6.3.20. Description
- 6.3.21. Parameters
- 6.3.22. Examples
- 6.3.23. Compatibility
- 6.3.24. See Also
- 6.3.25. Description
- 6.3.26. Parameters
- 6.3.27. Examples
- 6.3.28. Compatibility
- 6.3.29. See Also
- 6.3.30. Description
- 6.3.31. Parameters
- 6.3.32. Examples
- 6.3.33. Compatibility
- 6.3.34. See Also
- 6.3.35. Description
- 6.3.36. Parameters
- 6.3.37. Notes
- 6.3.38. Examples
- 6.3.39. Compatibility
- 6.3.40. See Also
- 6.3.41. Description
- 6.3.42. Parameters
- 6.3.43. Examples
- 6.3.44. Compatibility
- 6.3.45. See Also
- 6.3.46. Description
- 6.3.47. Parameters
- 6.3.48. Examples
- 6.3.49. Compatibility
- 6.3.50. See Also
- 6.3.51. Description
- 6.3.52. Parameters
- 6.3.53. Notes
- 6.3.54. Examples
- 6.3.55. Compatibility
- 6.3.56. Description
- 6.3.57. Parameters
- 6.3.58. Examples
- 6.3.59. Compatibility
- 6.3.60. See Also
- 6.3.61. Description
- 6.3.62. Parameters
- 6.3.63. Examples
- 6.3.64. Compatibility
- 6.3.65. See Also
- 6.3.66. Description
- 6.3.67. Parameters
- 6.3.68. Notes
- 6.3.69. Examples
- 6.3.70. Compatibility
- 6.3.71. See Also
- 6.3.72. Description
- 6.3.73. Compatibility
- 6.3.74. Description
- 6.3.75. Parameters
- 6.3.76. Examples
- 6.3.77. Compatibility
- 6.3.78. See Also
- 6.3.79. Description
- 6.3.80. Parameters
- 6.3.81. Examples
- 6.3.82. Compatibility
- 6.3.83. See Also
- 6.3.84. Description
- 6.3.85. Parameters
- 6.3.86. Examples
- 6.3.87. Compatibility
- 6.3.88. Description
- 6.3.89. Parameters
- 6.3.90. Examples
- 6.3.91. Compatibility
- 6.3.92. Description
- 6.3.93. Parameters
- 6.3.94. Examples
- 6.3.95. Compatibility
- 6.3.96. Informix Compatibility Mode
- 6.3.97. Oracle Compatibility Mode
- 6.3.98. Internals