how to shiow columns in postgres table code example
Example 1: describe table postgres
postgres=# \d schema.tablename;
Example 2: postgre describe table
SELECT
table_name,
column_name,
data_type
FROM
information_schema.columns
WHERE
table_name = 'city';