Re: Why not used standart SQL commands?

From: "Andreas 'ads' Scherbaum" <ads(at)pgug(dot)de>
To: Ali Koca <kinetixcicocuk(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Why not used standart SQL commands?
Date: 2022-01-08 22:18:26
Message-ID: CAMDzVO_-1P_7kcf9LeWE-qzqEnYxG39ZXcUk1p+bE204tLubhg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Jan 8, 2022 at 7:25 PM Ali Koca <kinetixcicocuk(at)gmail(dot)com> 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.
>

As others pointed out, "show databases" and "show tables" are not from any
standard.

Since you seem to come from MySQL, here is a list terms translated to
PostgreSQL:

https://wiki.postgresql.org/wiki/MySQL_PostgreSQL_terminology

Regards,

--
Andreas 'ads' Scherbaum
German PostgreSQL User Group
European PostgreSQL User Group - Board of Directors
Volunteer Regional Contact, Germany - PostgreSQL Project

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mohammed falih 2022-01-08 22:47:50 Re: The postgres server don't work
Previous Message Thomas Kellerer 2022-01-08 21:45:03 Re: Why not used standard SQL commands?