Better script to migrate existing partitions to partman?

[Faithfinder]

Current version in the docs parses partition names or data, but there must be a way to read the partition expression. Unfortunately my sql-fu isn't strong enough. Anyone cares to make the improvement:)?

[keithf4]

That's a good point. The show_partition_info function does contain code for reading the partition expression boundaries.

https://github.com/pgpartman/pg_partman/blob/master/sql/functions/show_partition_info.sql