"Get" compression policy

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! :wave:

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 :slight_smile:

1 Like