I have a table, named “Chats”, the name of schema is public and the name of the database is neondb. In SQL editor I am trying to access the data from “Chats” by using the command SELECT * FROM Chats also I ran the command SELECT * FROM public.chats but I am getting error. Kindly help.
Thank you.
When identifiers in queries are not quoted, PostgreSQL automatically downcases the name of the table used in the SQL statement.
So if your table is named Chats in the catalogs, and was created as CREATE TABLE "Chats", you’ll have to query it with SELECT * FROM "Chats", or SELECT * FROM public."Chats" in your case.
Does that solve the issue for you?
2 Likes
Thank you so much. Yes, it did resolve my issue.
1 Like