doltgresql icon indicating copy to clipboard operation
doltgresql copied to clipboard

`show create table` and `show tables` should not work

Open timsehn opened this issue 2 years ago • 2 comments

Why we taunting Postgres users?

employees=> show create table employees;
   Table   |                           Create Table                           
-----------+------------------------------------------------------------------
 employees | CREATE TABLE `employees` (                                      +
           |   `id` int NOT NULL,                                            +
           |   `last_name` varchar(255),                                     +
           |   `first_name` varchar(255),                                    +
           |   `start_date` date,                                            +
           |   PRIMARY KEY (`id`)                                            +
           | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin

timsehn avatar Oct 02 '23 21:10 timsehn

It turns out this should fail in Postgres. It is not supported syntax.

timsehn avatar Oct 02 '23 21:10 timsehn

Also show tables works and it should not.

  • \dt should be interpreted as show tables
  • \d tablename should be describe tablename
  • show create table should not work

timsehn avatar Oct 02 '23 21:10 timsehn

These no longer work

tbantle22 avatar Aug 21 '24 21:08 tbantle22