List tables on PostgreSQL schema

From PedrosBrainDump

Query

SELECT table_name FROM information_schema.tables WHERE table_schema = 'public';