unable to to run query
i have created table and inserted data by following : https://github.com/neondatabase/guide-neon-sequelize
my also Author.findAll() work properly . but in neon console https://console.neon.tech/app/projects/**/query error come which in picture.
i am able to see my data and table at neon but "select * from tableName" not work why???
#❓｜questions-and-answers
GitHub
GitHub - neondatabase/guide-neon-sequelize: Example application for...
Example application for Neon and Sequelize. Contribute to neondatabase/guide-neon-sequelize development by creating an account on GitHub.
7 Replies
gradual-turquoise•2y ago
I assume this is because the table is actually named "Books"? postgres differentiates between upper and lowercase names so you would need to do:
SELECT * FROM "Books";rare-sapphireOP•2y ago
@Flo i have tried all posibilities bro
gradual-turquoise•2y ago
can you show the table overview from the branch settings?
rare-sapphireOP•2y ago
@Flo here only todos Table works in "sql Editor" .todos table i have created in node,js
async function addTodo(){
const result=await sql
INSERT INTO todos (title, completed) VALUES ('Buy groceries', false)
;
console.log("result is ",result)
}
but why not Authors and Books not work
gradual-turquoise•2y ago
please try this and show me a screenshot of it not working
rare-sapphireOP•2y ago
@Flo oh yaa it's work !!! i am so fool. thank you very very much for helping me #Answered:amazing:
gradual-turquoise•2y ago
🤗