Received: from smartsoft.ro (oak.smartsoft.ro [193.226.123.254]) by hub.org (8.9.2/8.9.1) with SMTP id FAA56630 for ; Fri, 19 Feb 1999 05:01:20 -0500 (EST) (envelope-from gvoda@smartsoft.ro) Received: from oak.smartsoft.ro [193.226.123.254] by smartsoft.ro [127.0.0.1] with SMTP (MDaemon.v2.7.SP2.T) for ; Fri, 19 Feb 1999 12:00:53 +0200 Received: by oak.smartsoft.ro with Microsoft Mail id <01BE5BFF.7F998C30@oak.smartsoft.ro>; Fri, 19 Feb 1999 12:00:52 +0200 Message-ID: <01BE5BFF.7F998C30@oak.smartsoft.ro> From: Ghita Voda To: "'pgsql-sql@postgresql.org'" Subject: Insert a long text Date: Fri, 19 Feb 1999 12:00:48 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-MDaemon-Deliver-To: pgsql-sql@postgresql.org 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