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.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
