Postgres max field length issue

Question

We are trying to load some data in postgres The problem is data is huge that its exceeding character varying(10485760) limit.

Is there any possible way to increase this limit?

Thanks,

Answer 1

Use TEXT data type. It will allow you to enter long data. Use ALTER ... command for column data type.