Hey @Krydos,
I am still getting this error....
psycopg2.errors.UndefinedTable: relation "bee_data_table" does not exist
LINE 1: INSERT INTO bee_data_table (beekeeper_id, sensor_id, hive_te...
There is a little carrot ^ under the "b" of "bee_data_table" on the LINE 1
Here is what I am trying to insert:
INSERT INTO bee_data_table (beekeeper_id, sensor_id, hive_temp, hive_hum, weather_temp, weather_hum, time_taken) VALUES (ian, 2, 10, 10, 10, 10, 2020-09-29 13:07:09)
I am using the bee1_sensor_user, into the bee1_sensor_data DB
Any thoughts would be appreciated, thanks!