X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.193])
	by svr1.postgresql.org (Postfix) with ESMTP id BF9F430F3AA
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 18 Jun 2003 11:46:56 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new,
	port 10024) with ESMTP id 27761-01
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 18 Jun 2003 08:46:46 -0300 (ADT)
Received: from water.oasis.net.au (water.oasis.net.au [210.8.139.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 1C8BE30EEA7
	for <pgsql-sql@postgresql.org>; Wed, 18 Jun 2003 08:46:44 -0300 (ADT)
Received: from oasis.net.au (localhost [127.0.0.1])
	by water.oasis.net.au (8.9.3/8.9.3/Debian 8.9.3-21) with ESMTP id
	WAA06888
	for <pgsql-sql@postgresql.org>; Wed, 18 Jun 2003 22:02:04 +1000
X-Authentication-Warning: water.oasis.net.au: Host localhost [127.0.0.1]
	claimed to be oasis.net.au
From: "Rudi Starcevic" <rudi@oasis.net.au>
To: pgsql-sql@postgresql.org
Subject: Text insert max. size.
Date: Wed, 18 Jun 2003 22:02:04 +1000
Message-Id: <20030618120204.M81390@oasis.net.au>
X-Mailer: Open WebMail
X-OriginatingIP: 203.221.161.118
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
X-Archive-Number: 200306/211
X-Sequence-Number: 13969



Hi,

I'm doing some planning for storing some xml data and am wondering
what is the maximum amount I could insert with one SQL statement.

For example if I read an xml file off the hard drive and wanted to store
that in a text column what would be the largest file I could insert.
How about a 10 KB file ?

I guess also each programing language may have limitations too.
I this case I'm interested in using PHP.

Thank you kindly.

Regards
Rudi.