Heroku Postgres thowing an errror-> message relation "aspnetusers" does not exist from AspNetUsers

Asked Apr 25 '22 at 06:14

Active Apr 25 '22 at 06:24

Viewed 12 times

I am trying to query my data (SELECT * FROM AspNetUsers) in dataclips, however it's throwing an error message :

Dataclip Error ERROR: relation "aspnetusers" does not exist from AspNetUsers;

I would like to add that the table AspNetUsers is created using Asp.net EnitityFramworkCore and can successfully add and retrieve data from my local console app however when every I tried to query data from Heroku dataclip it is throwing an error which I have mentioned above.

The error message image is attached please check it out.

edited Apr 25 '22 at 06:24

a_horse_with_no_name

497,550
91
775
843

asked Apr 25 '22 at 06:14

Jaydeep Kasture

1

You probably need to use `SELECT * FROM "AspNetUsers"` – a_horse_with_no_name Apr 25 '22 at 06:24
Yes worked flawlessly thanks for your support @a_horse_with_no_name – Jaydeep Kasture Apr 25 '22 at 08:13

Heroku Postgres thowing an errror-> message relation "aspnetusers" does not exist from AspNetUsers

0 Answers0