Pgtcl Reference Manual
The PostgreSQL Tcl Interface
Copyright
© 1996-2006 The PostgreSQL Global Development Group and others
2006-05-29
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
Next
Preface