doltgresql
doltgresql copied to clipboard
`show create table` and `show tables` should not work
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
It turns out this should fail in Postgres. It is not supported syntax.
Also show tables works and it should not.
-
\dtshould be interpreted asshow tables -
\d tablenameshould bedescribe tablename -
show create tableshould not work
These no longer work