ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Warren <war...@clarksnutrition.com>
Subject table name and quotes:
Date Thu, 14 Jun 2007 19:40:01 GMT
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

Mime
View raw message