cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar

PostgreSQL query update issue

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.
1 REPLY 1
ih
Super User (Alumni) ih
Super User (Alumni)

Re: PostgreSQL query update issue

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);