how to find out field size?
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?
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