select 
      ordinal_position, 
      column_name, 
      data_type, 
      is_nullable,
      description.description as comment
  from 
      information_schema.columns columns
      left join pg_class class on (columns.table_name = class.relname)
      left join pg_description description on (class.oid = description.objoid)
      left join pg_attribute attrib on  (class.oid = attrib.attrelid and columns.column_name = attrib.attname and attrib.attnum = description.objsubid)
  where 
    table_name='{$tableName}' 
  group by
    ordinal_position, column_name, data_type, is_nullable, description.description

Get table schema with columns via sql.

Postgres get table schema with columns

sql, table

SQL