pgtclUtils.tcl
上传用户:blenddy
上传日期:2007-01-07
资源大小:6495k
文件大小:1k
- # 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_disconnect $conn
- return $datnames
- }