如何让这个查询起作用？
SELECT weather.id,cities.name,weather.date,weather.degree FROM weather JOIN weather.city_id ON cities.id WHERE weather.date = '2011-04-30';
错误：架构“天气”不存在.
天气不是架构,它是一张桌子！
也许：
原文链接：https://www.f2er.com/postgresql/238873.htmlSELECT weather.id,weather.degree FROM weather JOIN cities ON (weather.city_id = cities.id) WHERE weather.date = '2011-04-30';
postgres抱怨关于weather.city_id的加入,这被解释为模式’weather’中名为’city_id’的表/视图
