Text insert max. size.

From: "Rudi Starcevic" <rudi(at)oasis(dot)net(dot)au>
To: pgsql-sql(at)postgresql(dot)org
Subject: Text insert max. size.
Date: 2003-06-18 12:02:04
Message-ID: 20030618120204.M81390@oasis.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Anagha Joshi 2003-06-18 12:21:50 Create rule/trigger
Previous Message Tom Lane 2003-06-17 23:50:31 Re: yet pg_toast reindex