[ADMIN] Exec limit in pgtclsh

[Daniel J. Blezek, Ph.D.]

Hi all,

  Has anyone bumped into the 16K limit on the size of a statement using
pg_exec in the pgtclsh interface?  I'd like to populate a "text" field
using a large amount of text, but I get an error on the length limit of
the pg_exec call.  Something like this:


PQsendQuery() -- query is too long.  Maximum length is 16382

    while executing
"pg_exec $conn $statement"


Any ways around it?
-dan

--
Daniel Blezek, Ph.D.
[EMAIL PROTECTED]
Computer Graphics and Systems Program
Electronic Systems Lab
GE Corporate Research & Development


************