Thread: insert interface

insert interface

From
"Andrew O'Callaghan"
Date:
Hi!
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.

I found some docco about the copy command for bulk transactions, as well as
the large-object interface using pgtcl, but am not sure if this is the right
mechanism, since the amount of data I will be inserting is not great, or in
bulk.

Any help would be appreciated, or a pointer in the right direction of some more
docco.

regards,
Andrew O'Callaghan