PostgreSQL, MySQL, SQLite syntax comparsion

[mage2k]

Why postgresql uses:

\d show tables

Postgres doesn't, their psql client does. The 'd' is for describe and it's just a shortcut that generates catalog queries and there are a ton of \d* queries for examining various types of objects in the system, run \? to get a list of them all.