find coumn name and his type with greatest size in bytes - Mailing list pgsql-general

From Алексей Ефимов
Subject find coumn name and his type with greatest size in bytes
Date
Msg-id CAHCu-H8z3W1G+2qmr9BgWUb0QO02bBT+9DhG_ZBR2i9nH5Wexg@mail.gmail.com
Whole thread Raw
List pgsql-general
Hello all! 
can you help, i need to write a query that displays column name with his data type that have maximum bytes length in row for every table in database:

for example, for table employees with data:
emp_id,  emp_name, emp_dept, emp_surname
1              alexey         2                trew

i need to get such output: 

table_name, emp_id,          column_name,  bytes, datatype
employees              1           emp_name       6         text

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: crosstab
Next
From: Dominique Devienne
Date:
Subject: Re: public schema grants to PUBLIC role