FatalPostgresql ELT problem with update

[billimmer]

Hi Group,
Using 6.2.1 postgresql ELT input ----> map ----> output, there seems to be an issue I cannot work around (without resorting to the postgresqlrow component.
For the update to work I need to assign an alias in the elt output.  I check the "Use different table name" box and add:  "mytable myalias".
When I run the job I get:  UPDATE "myschema"."mytable myalias"
Note the quotes added around "mytable myalias", which produces a syntax error in postgresql
The result should be:  UPDATE "myschema"."mytable" "myalias"
Does anyone know of a workaround for this?
Thanks!

[cterenzi]

You might try something like "mytable\" \"myalias"

[billimmer]

Thanks for the reply.  I did try that and you get UPDATE "myschema".""mytable" "myalias"" which doesn't work.