Insert a long text

From: Ghita Voda <gvoda(at)smartsoft(dot)ro>
To: "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org>
Subject: Insert a long text
Date: 1999-02-19 10:00:48
Message-ID: 01BE5BFF.7F998C30@oak.smartsoft.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Brian Baquiran 1999-02-19 12:03:03 Re: [SQL] Insert a long text
Previous Message Anatoly K. Lasareff 1999-02-18 07:37:50 Re: [SQL] Question about SQL FUnction