Postgres OpenXML

Question

To start this off: Yes, I've read this post regarding OpenXML and postgres.

1. Is this still the case 6 years later?

2. If so, my company is converting from MS SQL Server to Postgres, with A LOT of stored procedures, many of which really rely on the OpenXML. It seems pretty cumbersome to have to write out a xpath() for every possible thing would would like to retrieve from our XML. Is there any recommendations you have to go about this conversion? An better alternative to xpath() that I haven't seen, yet?

Thanks!

Answer 1

After much research:

1) Yes, it appears so.

2) Yeah, it is kind of a pain, made an internal program that grabs potential XML paths and creates a script for us requiring only a few tweaks by hand.

Thanks