Re: Inserting large text strings into a Postgres DB

2001-03-30 Thread Jeff Duffy
On Fri, 30 Mar 2001 22:12:16 -0700, Mike Piatek alluded: > Is there any other way to accomplish this, or am I stuck with having files > with the text strings and a column indexing the filename? > > FYI: I'm using PostgreSQL 7.0.3. PostgreSQL 7.1 will remove the 32k row limit, allowing

Inserting large text strings into a Postgres DB

2001-03-30 Thread Mike Piatek
I am attempting to insert a large string of text into a Postgres database. When reading the Postgres documentation, it seemed that having a column with type = text would do the job. However, when I tried to do the insert, I hit the 8k tuple limit. I then tried to use lo_creat and lo_write