pgtcl is a Tcl package for client programs to interface with PostgreSQL servers. It makes most of the functionality of libpq available to Tcl scripts.
This package was originally written by Jolly Chen.
Table 3-1 gives an overview over the commands available in pgtcl. These commands are described further on subsequent pages.
Table 3-1. pgtcl Commands
| Command | Description |
|---|---|
pg_connect |
opens a connection to the backend server |
pg_disconnect |
closes a connection |
pg_conndefaults |
get connection options and their defaults |
pg_exec |
send a query to the backend |
pg_result |
manipulate the results of a query |
pg_select |
loop over the result of a SELECT statement |
pg_execute |
send a query and optionally loop over the results |
pg_listen |
establish a callback for NOTIFY messages |
pg_on_connection_loss |
establish a callback for unexpected connection loss |
pg_lo_creat |
create a large object |
pg_lo_open |
open a large object |
pg_lo_close |
close a large object |
pg_lo_read |
read a large object |
pg_lo_write |
write a large object |
pg_lo_lseek |
seek to a position in a large object |
pg_lo_tell |
return the current seek position of a large object |
pg_lo_unlink |
delete a large object |
pg_lo_import |
import a Unix file into a large object |
pg_lo_export |
export a large object into a Unix file |
The pg_lo_* routines are
interfaces to the large object features of PostgreSQL. The functions are designed to
mimic the analogous file system functions in the standard Unix
file system interface. The pg_lo_* routines should be used within a
BEGIN/COMMIT
transaction block because the file descriptor returned by
pg_lo_open is only valid for the
current transaction. pg_lo_import
and pg_lo_export must be used in a BEGIN/COMMIT
transaction block.
Example 3-1 shows a small example of how to use the routines.
Example 3-1. pgtcl Example Program
# getDBs :
# get the names of all the databases at a given host and port number
# with the defaults being the localhost and port 5432
# return them in alphabetical order
proc getDBs { {host "localhost"} {port "5432"} } {
# datnames is the list to be result
set conn [pg_connect template1 -host $host -port $port]
set res [pg_exec $conn "SELECT datname FROM pg_database ORDER BY datname"]
set ntups [pg_result $res -numTuples]
for {set i 0} {$i < $ntups} {incr i} {
lappend datnames [pg_result $res -getTuple $i]
}
pg_result $res -clear
pg_disconnect $conn
return $datnames
}