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.kla...@aklaver.com


Reply via email to