Postgres Pro
Downloads
Home   >   mailing lists

Re: Why not used standard SQL commands? - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Why not used standard SQL commands?
Date
Msg-id d31d4cf8-59f7-4707-e833-ab063cb31b19@gmx.net
Whole thread Raw
In response to Why not used standart SQL commands?  (Ali Koca <kinetixcicocuk@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Thomas Munro
Date:
Subject: Re: create database hangs forever on WSL - autovacuum deadlock?
Next
From: "Andreas 'ads' Scherbaum"
Date:
Subject: Re: Why not used standart SQL commands?