Connected to the prisma database with prisma user ...
# orm-helpa
ahebwa49
02/14/2019, 11:09 AMConnected to the prisma database with prisma user but the select statements won't retrieve the data in there. Anyone with an idea on how to go about it? I'm using postgres 10.5 with container(docker) @Harshit
h
Harshit
02/14/2019, 11:23 AMIs there any data there yet?
Harshit
02/14/2019, 11:24 AMAlso put a ; at the end
a
ahebwa49
02/14/2019, 11:39 AMAlright
ahebwa49
02/14/2019, 12:01 PMYes, there is some data
ahebwa49
02/14/2019, 12:03 PMI have successfully made atleast three mutations. I can even do queries in the GraphQL playground on localhost:4000
ahebwa49
02/14/2019, 12:04 PMThat's the error I'm now getting
ahebwa49
02/14/2019, 12:05 PM@Harshit
h
Harshit
02/14/2019, 12:05 PMTry
Harshit
02/14/2019, 12:06 PMdefault$default.Event
a
ahebwa49
02/14/2019, 12:09 PMSimilar error😕
ahebwa49
02/14/2019, 12:09 PM@Harshit
ahebwa49
02/14/2019, 12:23 PM@Harshit isn't it strange for the tables not to Exist?
h
Harshit
02/14/2019, 12:36 PM\dt default$default.
Harshit
02/14/2019, 12:36 PMplease show me the output of this
m
marcus
02/14/2019, 12:45 PMpostgres lowercases everything in your query unless you escape it properly
🙌 1
marcus
02/14/2019, 12:46 PMtry
Select * From “Event”
marcus
02/14/2019, 12:47 PMor maybe
Select * From “default$default”.“Event”
marcus
02/14/2019, 12:47 PMdrove me mad at first as well 😄
a
ahebwa49
02/14/2019, 1:04 PM@Harshit
h
Harshit
02/14/2019, 1:05 PMPlease try Marcus' solution
Harshit
02/14/2019, 1:05 PMSelect * From “default$default”.“Event”;
a
ahebwa49
02/14/2019, 1:05 PMOn it
ahebwa49
02/14/2019, 1:06 PM😅 @marcus You deserve a medal. 😂
🙌 3
ahebwa49
02/14/2019, 1:07 PM@Harshit thanks, you did it for me again!
😊 1
h
Harshit
02/14/2019, 1:07 PMIf you can please use a GUI to make this easy
a
ahebwa49
02/14/2019, 1:09 PMYeah, I'll right away use the ones you recommend earlier
3 Views