topic PostgreSQL query update issue in Discussions

PostgreSQL query update issue

MayurRJaiswal — Fri, 09 Jun 2023 19:47:00 GMT

While creating query in postgreSQL we need to use double quotes around every column name. In JMP scripts it is not allowing us the query with double quotes and throwing error.

Note: We are able to connect postgreSQL server successfully. While running query we are getting error saying "," or ")" missing.

Re: PostgreSQL query update issue

ih — Tue, 18 May 2021 16:36:19 GMT

You should be able to user double quotes in your query string using syntax similar to \!" as shown below. Can you post part of your query that is throwing the error?

str = "This is a \!"quoted phrase\!" inside a string.";

//When passed to other programs the quotes will look 'normal':
write(str);