Please just choose a single list to email. On Thursday, April 2, 2020, postgann2020 s <postgann2...@gmail.com> wrote:
> Hi Team, > > Good Evening, > > We are trying to syncing the table field size with other db tables filed > size. > I wouldn’t bother fiddling with arbitrary sizes, just remove,them. > We have multiple tables in multiple schemas in DB. we are tyring to > findout maximum size of each column in table for all tables and for all > schemas in DB. > You need to decide whether you want to query table data or catalog (schema) data. > > I have tried below query, but not able to get desired output. > > SELECT (select column_name from INFORMATION_SCHEMA.COLUMNS where > table_name='building'), select max(length(select column_name from > INFORMATION_SCHEMA.COLUMNS where table_name='building')) from from > INFORMATION_SCHEMA.COLUMNS where table_name='building' > group by column_name; > > If you want to dynamically determine tables and columns while still checking the actual table data you will need to create a dynamic sql statement to query the actual table with the content for the dynamic schema parts being populated by a query against information_schema or the catalog. You’d need you something besdies pure sql (e.g., pl/pgsql) to do this. You may find it easier to just brute force things. David J.
