Mostrar todas las tablas de un esquema POSTGRESQL

SELECT t.table_name FROM information_schema.tables t WHERE t.table_schema = 'public' ORDER BY t.table_name.