Heroku dataclips — relation does not exist

MJ
Mar 1, 2021

--

I encountered this error messages.

Dataclip ErrorERROR:  relation "wanteds" does not exist
LINE 1: select * from Wanteds;

Here is my sql query.

select * from Wanteds;

Here is my Schema Explorer.

What is wrong with this?

You need to type table name in double quotes like this

select * from "Wanteds";

--

--

MJ
MJ

Written by MJ

Fullstack Web Programmer in Korea

Responses (1)