Re: [ADMIN] Exec limit in pgtclsh

From: Jeroen Elassaiss-Schaap <j(dot)schaap(at)lumc(dot)nl>
To: "Daniel J(dot) Blezek, Ph(dot)D(dot)" <blezek(at)crd(dot)ge(dot)com>, pgsql-admin(at)postgreSQL(dot)org
Subject: Re: [ADMIN] Exec limit in pgtclsh
Date: 2000-03-08 13:15:42
Message-ID: 38C6527E.62FB33AF@lumc.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)schaap(at)physiology(dot)medfac(dot)leidenuniv(dot)nl

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Armin Diehl 2000-03-08 21:56:23 Re: [ADMIN] upper and german umlauts
Previous Message Roman Kurmanowytsch 2000-03-08 10:22:21 Re: [ADMIN] Cannot install postgreSQL