Hi,
We have a requirement wherein we have to store around 3 MB of data in
Postgres database.
We had gone through the postgres website
http://www.postgresql.org/docs/7.4/interactive/datatype-character.html#DATATYPE-CHARACTER-SPECIAL-TABLE
The above link says varchar can store upto 1 GB of
Vadivel Subramaniam [EMAIL PROTECTED] writes:
2. create table utilntmlscripts (name character varying, data character
varying(10485770));
ERROR: length for type 'varchar' cannot exceed 10485760
It's not allowing more than 10 MB of size during table creation.
Use type text, or