Put "" around the column name, eg:
insert into "limit" values (1, 2,3 );
Chris
Gourish Singbal wrote:
Guys,
I am having a problem firing queries on one of the tables which is having "limit" as the column name.
If a run an insert/select/update command on that table i get the below error.
ERROR: syntax error at or near "limit" at character 71
Any Help would be realyl great to solve the problem.
postgresql 7.4.5 and linux OS
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
