[Feature]: get hypertable and continuous aggregation (materialized views) definition for existing ones

[ecerichter]

What problem does the new feature solve?

I've several hypertables, and not all of them have been documented.
In PostgreSQL, there are several internal tables that help to obtain the definition of objects, for example, to get the definition of a view, I just issue:

select pg_get_viewdef('viewname', true)

Would be a great adittion to timescaleDB if I can get a way to obtain the hypetable and aggregation (materialized) views definition as when created.

What does the feature do?

Enable DBD and DBA to get the definition for timescaledb objects, mainly hypertables and continuous aggregation (materialized views).

Implementation challenges

Would be necessary to store the creation command in the timescale catalog.

[salisbury-espinosa]

Would be a great adittion to timescaleDB if I can get a way to obtain the hypetable and aggregation (materialized) views definition as when created.

select * from timescaledb_information.continuous_aggregates;

select * from timescaledb_information.hypertable

This? @ecerichter

Would be necessary to store the creation command in the timescale catalog.

view_definition in timescaledb_information.continuous_aggregates:

select view_definition from timescaledb_information.continuous_aggregates;