How can I create a COPYfunction with myBatis mapper in the xml file?

Question

How Can I create a COPY function in the .xml mapper with myBatis? And what values this function will return? I think it is as

<copy id="copyFunction">
    COPY (SELECT * FROM #{table_name} WHERE backup = 1) TO 'C:\var\audiobays\logs\audit\' || #{table_name} || '_deletions_(' || now()::DATE || '-' || days || ').csv'' CSV DELIMITER '','' HEADER;'
</copy>

But I'm not sure that it is what.
Can someone help me? Thank you!

score 1 · Accepted Answer · answered Aug 29 '19 at 09:54

1

You can't as mybatis does not implement support for copy.

COPY is postgresql specific command and it is not supported in JDBC. To use it postgresql specific classes like CopyManager are needed.

mybatis uses JDBC to access database and does not provide support for non standard features like this.

answered Aug 29 '19 at 09:54

Roman-Stop RU aggression in UA

14,905
3
48
53

Can do you take mi a mini-example? Thank's – Michele Verriello Aug 29 '19 at 10:08
Ok, I didn' t see the link. Thank you! – Michele Verriello Aug 29 '19 at 10:44

How can I create a COPYfunction with myBatis mapper in the xml file?

1 Answers1