I have tried to run an
INSERT query in Pgsql using PgAdmin. The table name is
todo-list. However, when I try to run it, an error message appears:-
syntax error at or near "-" LINE 1: INSERT INTO todo-list(todo_title,todo_description,todo_image... ^
The query that I want to run is
INSERT INTO todo-list(todo_title,todo_description,todo_image,todo_status) VALUES("efrgthnj","wefrgtbhnj","qwefgrthj",1)
I tried using "todo-list", but that didn't work either. What should I do?
"todo-list"But preferably you'd do yourself a favor, if you want special characters in object names nor use case sensitives object names.