Thread: how to find out field size?
Postgres documentation says: maximum field size is 1 GB.
So, how to find out the size of column to see how far it from the limit?
Regards,
David
On 4/4/22 08:28, Shaozhong SHI wrote: > Postgres documentation says: maximum field size is 1 GB. > PostgreSQL: Documentation: 12: Appendix K. PostgreSQL Limits > <https://www.postgresql.org/docs/12/limits.html> > > So, how to find out the size of column to see how far it from the limit? Documentation also shows: https://www.postgresql.org/docs/current/functions-admin.html pg_column_size ( "any" ) → integer Shows the number of bytes used to store any individual data value. If applied directly to a table column value, this reflects any compression that was done. > > Regards, > > David > -- Adrian Klaver adrian.klaver@aklaver.com