Re: [SQL] Text insert max. size.

2003-06-18 Thread scott.marlowe
On Wed, 18 Jun 2003, Rudi Starcevic wrote: > 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. There's no limit to max SQL statement size in postgresql, but practically, you might want a REALLY big mach

[SQL] Text insert max. size.

2003-06-18 Thread Rudi Starcevic
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 K