Re: Maximum size for char or varchar with limit

On Wednesday 08 December 2010 5:47:25 am Rob Gansevles wrote:
> Hello,
>
> Does anyone know what the maximum length is for char or varchar
> columns with limit.
> I saw some answers to this same question referring to section 8.3 of
> the docs, but I don't see the actual numbers there.
>
> I know you can go to 1GB if you don't specify the limit, but I would
> like to know what the max limit is you can use.
>
> It seems to be 10485760 in my install.
> Is this fixed in PostgreSQL or does it depend on some configuration
> setting? Does it depend on the version (I am using 8.4)?
>
>
> Here is my test-sql:
>
> create table test (x varchar(100000000))
>
> Error: ERROR: length for type varchar cannot exceed 10485760
> SQLState: 22023
> ErrorCode: 0
>
> Thanks in advance,
>
> Rob

I think you are looking for this:
http://wiki.postgresql.org/wiki/FAQ#What_is_the_maximum_size_for_a_row.2C_a_table.2C_and_a_database.3F

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com