Re: Need help with Visual Basic 6 and PostgreSQL - Mailing list pgsql-odbc

From Tom Lane
Subject Re: Need help with Visual Basic 6 and PostgreSQL
Date
Msg-id 24750.1195871139@sss.pgh.pa.us
Whole thread Raw
In response to Re: Need help with Visual Basic 6 and PostgreSQL  (Richard Broersma Jr <rabroersma@yahoo.com>)
Responses Re: Need help with Visual Basic 6 and PostgreSQL  (Richard Broersma Jr <rabroersma@yahoo.com>)
List pgsql-odbc
Richard Broersma Jr <rabroersma@yahoo.com> writes:
> For what it is worth, Postgresql has a 1 Gb limit on the size of a text field. So if you know that you ascii chars
are8 bits, then you should be able to store a little over 134,000,000 characters. 

Uh, the hard limit is 1 gigabyte, not 1 gigabit.

(Whether you can approach the limit with reasonable performance is
another question ... I wouldn't try it in a 32-bit machine, for sure.)

            regards, tom lane

pgsql-odbc by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: Need help with Visual Basic 6 and PostgreSQL
Next
From: Richard Broersma Jr
Date:
Subject: Re: Need help with Visual Basic 6 and PostgreSQL