I want to know tables' columns' sizes, to limit inputs' length in the form (I'm also checking it in the backend).
How can I know this?
-
2possible duplicate of stackoverflow.com/a/12395731/3961156Dzmitry Savinkou– Dzmitry Savinkou2015-10-06 14:17:44 +00:00Commented Oct 6, 2015 at 14:17
-
1postgresql.org/docs/current/static/infoschema-columns.htmluser330315– user3303152015-10-06 14:22:23 +00:00Commented Oct 6, 2015 at 14:22
Add a comment
|
1 Answer
Try this query, it returns all the column name, data type, maximum lengths for a given table 'table_name'.
SELECT column_name, data_type, character_maximum_length
FROM information_schema.columns
WHERE table_schema = 'public'
AND table_name = 'table_name';
You could modify it to return one column replacing 'column_name' with yours like so:
SELECT column_name, data_type, character_maximum_length
FROM information_schema.columns
WHERE table_schema = 'public'
AND table_name = 'table_name'
AND column_name = 'column_name';
Comments
