Fetch Datatype Size PostgreSQL

Question

I'm fetching data from a PostgreSQL database. All is working fine, however i want to select the size of the data_type as well however i cant get that to work. Please help Here's my query:

 $result2 = pg_query($dbconn, "SELECT table_name as tabela, column_name as campo, data_type as tipo from information_schema.columns where table_schema = 'public'");

Answer 1

your sql works fine.

I'd say you user does not have permission (Read) to the table(s) its asking to view ?

You could try this

GRANT SELECT ON ALL TABLES IN SCHEMA PUBLIC TO youruser;

For the size of the column you could you the System Administration Function

pg_column_size(data_type)

" pg_column_size(any) returns an int Which is the Number of bytes used to store a particular value (possibly compressed) "

SELECT table_name as tabela, column_name as campo, 
data_type as tipo,pg_column_size(data_type) as tipo1 from
information_schema.columns where table_schema = 'public'

Results

Ref Postgresql 9.5 section 9.26. System Administration Functions

All the best