Yes, and since "show the tables" isn't in SQL itself, each CLI ends up having a different command for doing it, which makes a universal CLI appealing to me... if it can do that.
Actually
SELECT table_name FROM information_schedule.tables;
But yes, that's harder to type/remember than \d.https://webstore.iec.ch/preview/info_isoiec9075-11%7Bed4.0%7...
Not the actual standard though, that'll cost you a few hundred bucks.
[edit - you can see the 1992 complete version here; do a search for information_schema.
http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt
courtesy of Ian Winand - https://modern-sql.com/standard]
to get a zip file of pdfs. The schema is in 7IWD2-11-Schemata-2011-12.pdf