Re: how to find out field size?

[Adrian Klaver <adrian.klaver@xxxxxxxxxxx>]

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@xxxxxxxxxxx