issue with one of tables in psql

[galyverasi]

ERROR: relation "userrestaurants" does not exist

I've tried dropping the table and recreating it

[mgkdn9]

I'm having the same issue I think:

           List of relations
 Schema |     Name      | Type  | Owner 
--------+---------------+-------+-------
 public | SequelizeMeta | table | user
 public | responses     | table | user
 public | toolRequests  | table | user
 public | users         | table | user
(4 rows)

OoIHaveThat_development=# select * from toolRequests;
ERROR:  relation "toolrequests" does not exist
LINE 1: select * from toolRequests;

are you seeing the data exists with \dt?

[DoireannJane]

Seems like a schema issue but you're in public. Galyver are you in public?

[galyverasi]

Yes in public. All other tables are fine. userRestaurants gives me this error

               List of relations
 Schema |      Name       | Type  |   Owner    
--------+-----------------+-------+------------
 public | SequelizeMeta   | table | galyverasi
 public | restaurants     | table | galyverasi
 public | reviews         | table | galyverasi
 public | userRestaurants | table | galyverasi
 public | users           | table | galyverasi
(5 rows)

leggo_my_veggo_development=# SELECT * FROM userRestaurants;
ERROR:  relation "userrestaurants" does not exist
LINE 1: SELECT * FROM userRestaurants;

[DoireannJane]

It's capitalized SELECT and try putting quotes around toolRequests and userRestaurants!

[DoireannJane]

Let me know if this works for you

[mgkdn9]

quotes worked!