Pgtcl Reference Manual

The PostgreSQL Tcl Interface

Legal Notice

2007-01-15


Table of Contents

Preface
1. Overview
2. Building and Installing pgtcl-ng
2.1. Building and Installing on Unix-like Systems
2.1.1. Prerequisites for Unix-like Systems
2.1.2. Building and Installing - Unix-like Systems
2.2. Building and Installing on Windows Systems (Borland Compiler)
2.2.1. Prerequisites for Windows Systems
2.2.2. Building and Installing - Windows Systems
2.3. Building and Installing on MacOS 10
2.3.1. Prerequisites for MacOS Systems
2.3.2. Building on MacOS
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 - Asynchronous Query with Event-Driven Results
5.13. Example - COPY FROM and COPY TO