describir los postgres de la tabla
postgres=# \d schema.tablename;
ver esquema de tabla detallado postgresql
-- All information
SELECT * FROM information_schema.columns
WHERE table_schema = 'some_schema'
AND TABLE_NAME = 'some_table';
-- Or a more simplified version
SELECT
table_name,
column_name,
data_type
FROM
information_schema.columns
WHERE
table_name = 'some_table';
1) PostgreSQL DESCRIBE LA TABLA usando psql
\d table_name or \d+ table_name
or
SELECT
table_name,
column_name,
data_type
FROM
information_schema.columns
WHERE
table_name = 'city';
postgre describir tabla
SELECT
table_name,
column_name,
data_type
FROM
information_schema.columns
WHERE
table_name = 'city';