How do you export a jar file from a SQL database and reuse the jar file?

[linden linden]

I use an old plugin called the Space Usage Report plugin, developed by the university of Iowa. I now want to use it in a new wiki, but I can't find the jar file anywhere.

I can find it in the database table called PLUGINDATA, but when my DBA exports it from the database it's corrupt or not in the right format.

Has anybody been able to export a jar file from the database and successfully reuse it?

Thanks
Linden

[Alejandro Conde Carrillo · Accepted solution]

In posgresql:

\copy (select encode(data,'hex') from plugindata where filename='plugin-filename.jar') TO '/destination/path/plugin-filename.hex'

Then on linux do:

xxd -p -r /destination/path/plugin-filename.hex /destination/path/plugin-filename.jar