Pgtcl Reference Manual

The PostgreSQL Tcl Interface

2004-11-08


Table of Contents
Preface
1. Overview
2. Building and Installing pgtcl
2.1. Building and Installing on Unix-like Systems
2.2. Building and Installing on Windows Systems (Borland Compiler)
2.3. Building and Installing on MacOS 10
3. Loading pgtcl into an Application
3.1. Using the Tcl Package Command
3.2. Directly loading libpgtcl
3.3. Linking libpgtcl Into an Application
4. pgtcl Command Reference
4.1. Database Connection Control Commands
4.2. Connection Status Commands
4.3. Query Execution Commands
4.4. Asynchronous Query Processing Commands
4.5. Notification and Notice Processing Commands
4.6. Large Object Processing Commands
5. Example Programs
5.1. Example - Connect and query with pg_exec
5.2. Example - Connect and query with pg_execute
5.3. Example - Get List of Databases
5.4. Example - The Different Ways to Get Query Results
5.5. Example - Large Objects - Picture Viewer, Part 1 - Store Pictures
5.6. Example - Large Objects - Picture Viewer, Part 2 - View Pictures
5.7. Example - Prepared Queries - Picture Viewer, Part 1 - Store Pictures
5.8. Example - Prepared Queries - Picture Viewer, Part 2 - View Pictures
5.9. Example - Bytea Escaping - Picture Viewer, Part 1 - Store Pictures
5.10. Example - Bytea Escaping - Picture Viewer, Part 2 - View Pictures
5.11. Example - Asynchronous Queries
5.12. Example - COPY FROM and COPY TO
List of Tables
1-1. pgtcl Commands
List of Examples
5-1. Connect to the database and get its version with pg_exec
5-2. Connect to the database and get its version with pg_execute
5-3. Connect and get list of databases - pg_exec
5-4. Connect and get list of databases - pg_select
5-5. Result data: -getTuple
5-6. Result data: -tupleArray
5-7. Result data: -assign
5-8. Result data: -list
5-9. Result data: -llist
5-10. Result data: -assignbyidx
5-11. Large Objects - Store Pictures in Database
5-12. Large Objects - View Pictures Stored in Database
5-13. Prepared Queries - Store Pictures in Database
5-14. Prepared Queries - View Pictures Stored in Database
5-15. Bytea Escaping - Store Pictures in Database
5-16. Bytea Escaping - View Pictures Stored in Database
5-17. Asynchronous Queries
5-18. COPY TO
5-19. COPY FROM