-- show tables
SELECT * FROM pg_catalog.pg_tables;

-- describe table
select column_name, data_type, character_maximum_length from INFORMATION_SCHEMA.COLUMNS where table_name = 'tablename';