A psql meta-command, not SQL: backslash commands run inside the psql session and talk to the server for you. \dt shows each table's schema, name, and owner; \dt+ adds size and description. Related: \d users describes one table.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.