在Heroku上使用Postgres 9.3.2。
我相信我只是个傻瓜,但是我似乎无法弄清楚我的语法为什么有问题。
db=> \dt
List of relations
Schema | Name | Type | Owner
--------+------------+-------+----------------
public | device | table | admin
public | post | table | admin
public | user | table | admin
(3 rows)
// why does this fail?
db=> drop table user;
ERROR: syntax error at or near "user"
LINE 1: drop table user;
// does the right thing
db=> drop table error;
ERROR: table "error" does not exist