Re: [SQL] Insert a long text - Mailing list pgsql-sql

From Brian Baquiran
Subject Re: [SQL] Insert a long text
Date
Msg-id Pine.OSF.3.91.990219200042.15691A-100000@athena.evoserve.com
Whole thread Raw
In response to Insert a long text  (Ghita Voda <gvoda@smartsoft.ro>)
List pgsql-sql
On Fri, 19 Feb 1999, Ghita Voda wrote:

> Hello!
>
> I want to insert a long text (up to 10.000 words) into a table (for example, table1) into a field (field1) which is a
'text'field. 
> I have tried the followings:
> INSERT INTO table1 VALUES (' long text'...)
> UPDATE table1 SET field1='long text'
> and is not working.
> I'm using servlets and Apache server, on Linux.

What data type are you using for the text field? As far as I know, the 'text'
datatype can only take 8K.

I don't know what the maximum size for varchar is.

Brian
--
"No matter how cool your interface,
  it would be better if there were less of it"  -- Alan Cooper


pgsql-sql by date:

Previous
From: Ghita Voda
Date:
Subject: Insert a long text
Next
From: tolik@icomm.ru (Anatoly K. Lasareff)
Date:
Subject: Re: [SQL] Insert a long text