postgresql - postgresql 中不存在列和表之间的关系，即使它确实存在

Question

我的数据库中的表列表如下：

clicktracker=> \dt
                 List of relations
 Schema |       Name        | Type  |    Owner
--------+-------------------+-------+--------------
 public | app_events        | table | trackeradmin
 public | apps              | table | trackeradmin
 public | device_info       | table | trackeradmin
 public | ip_addresses      | table | trackeradmin
 public | third_party_login | table | trackeradmin
 public | traffic           | table | trackeradmin
 public | users             | table | trackeradmin

这是表“用户”的内容。

clicktracker-> \d users
                                                   Table "public.users"
          Column       |            Type             | Collation | Nullable |                     Default
    -------------------+-----------------------------+-----------+----------+----------------------------
     Ip Address        | character varying(50)       |           |          |
     Store Country     | character varying(50)       |           |          |
     Visit Time        | timestamp without time zone |           |          |
     User Unique ID    | integer                     |           | not null | nextval('"users_User Unique ID_seq"'::regclass)
     Phone Number      | character varying(50)       |           |          |
     Email             | character varying(50)       |           |          |
     Passwords         | character varying(50)       |           |          |
     3rd Party User Id | integer                     |           |          |
     Login Type        | character varying(50)       |           |          |
     App Id            | character varying(40)       |           |          |
     code              | character varying           |           |          |
     verified          | integer                     |           |          |

如您所见，此处明显存在“密码”列。但是，当我尝试将“密码”列的类型更改为 VARCHAR(100) 时，会发生此错误。

clicktracker=> ALTER TABLE users ALTER COLUMN passwords TYPE varchar(100);
ERROR:  column "passwords" of relation "users" does not exist

我已经在谷歌上搜索了几个小时来解决这个问题，但没有得到任何结果。有人在这里发现问题吗？

标签： postgresql