> since "show the tables" isn't in SQL itself,
Actually
SELECT table_name FROM information_schedule.tables;
But yes, that's harder to type/remember than \d.