Insert a long text - Mailing list pgsql-sql

From Ghita Voda
Subject Insert a long text
Date
Msg-id 01BE5BFF.7F998C30@oak.smartsoft.ro
Whole thread Raw
Responses Re: [SQL] Insert a long text  (Brian Baquiran <brianb@evoserve.com>)
List pgsql-sql
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.

In MSAccess is working also this statement:
UPDATE table1 SET field1 = field1 & 'short text'
but in postgres I don't know how to do this.
Thank you,

Ghita Voda


pgsql-sql by date:

Previous
From: tolik@icomm.ru (Anatoly K. Lasareff)
Date:
Subject: Re: [SQL] Question about SQL FUnction
Next
From: Brian Baquiran
Date:
Subject: Re: [SQL] Insert a long text