I'm trying to add inputs from a Postgres database, but it creates the default query using the context variables for the database. This would be fine, except it errors and says the statement is incorrect.

Here is what it defaults to:
"SELECT \""+context.dbname_Schema+"\".\"tablename\".\"columnname\", \""+context.dbname_Schema+"\".\"tablename\".\"columnname2\"
+" FROM \""+context.dbname_Schema+"\"."tablename\""

I then have to manually redo the statement to look like this:
"SELECT tablename.columnname, tablename.columnname2 FROM tablename"

The context variables work for everything else, so it seems to be the query generation causing the problem.

Is there a way to make it default to the second method (while leaving the connection contexts intact), or at least make the default statement correct? I've been doing it manually so far, but each table has 30-40 columns making it very repetitive. I'm also reading from an Access database using context variables and tAccessInputs and it works fine, with queries looking like the second one above. If anybody has any suggestions it would be greatly appreciated.

Thanks,
Phil