On 1/8/22 10:25, Ali Koca wrote:
Hello,
I'm seeing \dt used for "show tables", \l used for "show databases". Why
not standart SQL syntax words? Why specified PostgreSQL commands?
I can't figure out that.
AFAIK, SHOW TABLES is a MySQL thing.
See here:
https://www.sqltutorial.org/sql-list-all-tables/
If you are looking for a 'standard' method then look at:
https://www.postgresql.org/docs/current/information-schema.html
in particular:
https://www.postgresql.org/docs/current/infoschema-tables.html
Ali
--
Adrian Klaver
adrian.kla...@aklaver.com
