I see the functions “add_compression_policy” and “remove_compression_policy”. What do I use to check current existing compression policy or policies?
1 Like
Hello benneharli!
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.
3 Likes
Looks like exactly what I need - thanks
1 Like