Hi,
I'm trying to import a CSV file into a PostgreSQL DB.
Customer requires all data from appian must rely on that DB which is connected as datasource.
I'm using the plug in Excel tool and the Smart Service Import CSV to Database.
I got the following error from stdOut log:
ERROR ImportCsvToDatabase8 Error executing SQL org.postgresql.util.PSQLException: ERROR: syntax error at or near "," Position: 17
From database, i turned statements log on and i found out the following statement:
2024-03-29 17:32:08 UTC:10.245.48.249(51148):appian@postgres:[3319]:ERROR: syntax error at or near "," at character 17 2024-03-29 17:32:08 UTC:10.245.48.249(51148):appian@postgres:[3319]:STATEMENT: select `field1`, `field2` from `table` where 1=0 2024-03-29 17:32:08 UTC:10.245.48.249(51148):appian@postgres:[3319]:LOG: execute S_1: ROLLBACK
I'm running the same statement on my client in Postgres and i got the same error of course.
What I found out is that backtick is causing problems as it as a different use on o Postgres than MariaDb.
Do you know any workaround to bypass this problem?
Something to skip/bypass the backtick and use something different?
Thanks a lot
Alessandro
Discussion posts and replies are publicly visible
A last note about this: it has turned out that in plugin version 2.6.3, released on April 27 2024, support for Postgres was added. And it works, or at least it does in our case.