I see the functions “add_compression_policy” and “remove_compression_policy”. What do I use to check current existing compression policy or policies?
You can use some of our informational views to get that information. If you run this command, it will show all your policies, including the compression one!
SELECT * FROM timescaledb_information.jobs;
Hopefully, this helps, but let me know if you have any other questions.
Looks like exactly what I need - thanks