postgres cheatsheet

postgres-cheatsheet.sql

-- find tables
SELECT *
FROM information_schema.tables
WHERE table_schema = 'public'
and table_name like '%pattern%'
ORDER BY table_type, table_name;

-- DESC table
SELECT 
   table_name, 
   column_name, 
   data_type 
FROM 
   information_schema.columns
WHERE 
   table_name = '<table_name>';