CODE EXAMPLE FOR SQL

postgres read table structure

SELECT column_name, data_type, character_maximum_length
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_name ='table_name';