我是postgresql的新手,但似乎无法删除一个表。
db_dev=# \dt
List of relations
Schema | Name | Type | Owner
--------+-------------+-------+-------
public | DataSources | table | ted
public | Emails | table | ted
public | Users | table | ted
(3 rows)
当我尝试删除用户表时,它会出现错误:
db_dev=# drop table Users;
ERROR: table "users" does not exist
我做错了什么?
drop table public.Users;
命令?但是会返回相同的错误提示ERROR: table "users" does not exist
。 - Ted Tomlinson