you would need to use the literal notation of $tablename$. Caution, it opens
you to the possibility of of SQL injection.
Brandon
On 6/14/07, Warren <[EMAIL PROTECTED]> wrote:
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
