Postgres Pro
Downloads
Home   >   mailing lists

Re: how to find out field size? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: how to find out field size?
Date
Msg-id 0c02aafa-6079-d6ad-fa1d-a3c36cb8cd19@aklaver.com
Whole thread Raw
In response to how to find out field size?  (Shaozhong SHI <shishaozhong@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Shaozhong SHI
Date:
Subject: how to find out field size?
Next
From: Michael Nolan
Date:
Subject: Re: Trigger functions and FDW tables