Why does Postgresql say "schema does not exist"

Question

How can i get this query to work?

SELECT weather.id, cities.name, weather.date, weather.degree
FROM weather JOIN weather.city_id ON cities.id
WHERE weather.date = '2011-04-30';

ERROR: schema "weather" does not exist.

weather is not schema, it's a table!

user533832 · Accepted Answer · 2011-04-29 08:51:45Z

11

perhaps:

SELECT weather.id, cities.name, weather.date, weather.degree 
FROM weather JOIN cities ON (weather.city_id = cities.id)
WHERE weather.date = '2011-04-30';

postgres is complaining about the join on weather.city_id which is interpreted as a table/view called 'city_id' in schema 'weather'

answered Apr 29, 2011 at 8:51

user533832

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Why does Postgresql say "schema does not exist"

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related