Re: [INTERFACES] Message-id: <37d5c912.1673.0@chariot.net.au>

On Wed, 8 Sep 1999, Andrew O'Callaghan wrote:

==>I am new to postgresql, and am trying to create an interface to the database
==>so that I can insert records into a table from, say, a Tcl/Tk GUI. I am having
==>trouble finding any examples where this has been done. Most interface examples
==>are for extracting data from the database, ie. queries, but not for inserting
==>it into the database.

It's basically as simple as forming a correct SQL insert command. The
general format is
"insert into <table>(col1,col2,...,coln) values(val1,val2,...,valn);"

Then, just use pg_exec to execute the SQL query. There isn't really
anything returned, like there is with an pg_select, so just get the
result and if necessary, the error.

Here's a short example: (globs(conn) was opened previously)

set sql "insert into images(image_id,name,dest,source,source_type,\
show_copy_p,copyright,res,border_p,title,description,technotes) "
append sql "values(nextval('image_seq'),'$name','$Defaults(dest)','$file',\
'$type','t','$Defaults(copy)','$Defaults(res)','t','','','');"
set result [ pg_exec $globs(conn) $sql ]
set status [ pg_result $result -status ]
set error [ pg_result $result -error ]

~~~~~~
| | Rusty Brooks
|c--OD The University of Texas at Dallas
| _) Computer Science Dept.
| |
|-. | http://www.utdallas.edu/~rbrooks
/ `-# /A
/ /_|..`#.J/ Statisticians probably do it.

Better by far you should forget and smile than that you should remember
and be sad.

If a picture is worth a thousand words, then television must be worth
30,000 words per second.
-- Rusty Brooks