I am using the copy command of postgres and have an sql map like this:

  <statement id="importTextFile" parameterClass="java.util.Map">
    COPY sometable FROM #filename#
  </statement>

I would like to use something like this:

  <statement id="importTextFile" parameterClass="java.util.Map">
    COPY #tablename# FROM #filename#
  </statement>

The sql map at the top works, but the one below it does not. It constructs the statement as:

    COPY 'sometable' FROM 'somefile'

I need the quotes removed around the table name.

--
Thanks,

Warren

Reply via email to