Re: [ADMIN] Exec limit in pgtclsh - Mailing list pgsql-admin

From Jeroen Elassaiss-Schaap
Subject Re: [ADMIN] Exec limit in pgtclsh
Date
Msg-id 38C6527E.62FB33AF@lumc.nl
Whole thread Raw
In response to Exec limit in pgtclsh  ("Daniel J. Blezek, Ph.D." <blezek@crd.ge.com>)
List pgsql-admin
> 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"

1. Divide text among different entries
2. Use large objects


Jeroen


--
J. Elassaiss-Schaap
Dept. Physiology
Leiden University Medical Centre
Postbus 9604
2300 RC Leiden
The Netherlands

tel: 071-5276811
fax: 071-5276782
E-mail: j.schaap@physiology.medfac.leidenuniv.nl

pgsql-admin by date:

Previous
From: "miguel valero"
Date:
Subject: Re: [ADMIN] Database Import
Next
From: Matthew
Date:
Subject: RE: [ADMIN] Database Import