Good afternoon community, My application is mainly used on sap ase and oracle but more and more client are moving to postgres. One of the feature is the ability to define a table columns with datatype and datalength) that is fed through SQL also defined in the app. Once defined, the app manages the table création. When the app is moved to postgres,we joticed the tab définition is changed especially the columns datalength. With some unit and the help of AI my understand is the typmod is not returned or undefined when using function or union. I understand what the AI explains but I'd like the expérience and explanation from real user. What is type modifier? Where can find explanations about it in the documentation ans it's limitation and how to check the values when running SQL? Thanks for reading submitted by /u/rebirthofmonse [link] [comments]