I get the following error:
test=# Select * from Venue;
ERROR: relation "venue" does not exist
LINE 1: Select * from Venue;
But as you can see here the table exist:
I have already spent more than 2 hours, and I cant find my error
Asked
Active
Viewed 1,970 times
1
a_horse_with_no_name
- 497,550
- 91
- 775
- 843
user8495738
- 147
- 1
- 2
- 13
-
2https://wiki.postgresql.org/wiki/Don't_Do_This#Don.27t_use_upper_case_table_or_column_names – a_horse_with_no_name Dec 20 '19 at 06:58
-
try your select statment like - Select * from public."Venue" – Kandy Dec 20 '19 at 07:00
-
Hello everybody thanks for your help, so the problem was that I had several open connections to vagrant. After I restarted my computer everything worked fine – user8495738 Dec 20 '19 at 07:15