Search Postgresql Archives

Re: Why not used standard SQL commands?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Ali Koca schrieb am 08.01.2022 um 19:25:
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.

The only thing the SQL standard defines to gain access to information about
tables, schemas and catalogs (=databases) is the information_schema views.

There is no "show database" or "show tables" statement in the SQL standard.


Btw: \dt is a command specific to the psql client - it's not a general
"SQL command" in Postgres







[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux