[Feature Request]: Add PostGIS relations comments in report

[evinouze]

Context

No response

Description

A great thing would be to add comments of PostGIS tables/view that generally contain relevant metadata for its potential users.

Related links

Nothing related to this proposal, as far as I know

Use Cases

Add relevant information in the generated report

Visuals

No response

Before submitting

• I have verified that my idea is a change request and not a bug report.

[evinouze]

I forgot to specify that I've used the 4.0.0beta9 version. beta10 version is, as I understood, not compatible with my Linux OS version (Zorin 17.3 that is based on Ubuntu 22.04)

[Guts]

Hello @evinouze

It's a really good idea and very in line with this project's spirit but I've no paid time on this project so I'm afraid that you will have to wait, do it or fund 😬.

Regarding your issue with OS, try the new beta version https://github.com/Guts/DicoGIS/releases/tag/4.0.0-beta11

[evinouze]

Hope Santa Claus will be generous this year!

More seriously, I'm not surprised about your answer. The purpose of this suggestion was more to trace this idea. No attempt to get it for free ;-)
Meanwhile, I've written down a SQL request to get relation description in order to attach results to the generated report. Still some adjustments to make it work, but it should make the job.

[evinouze]

Meanwhile, I've written down a SQL request to get relation description in order to attach results to the generated report. Still some adjustments to make it work, but it should make the job.

SELECT
	concat(gc.f_table_schema, '.', gc.f_table_name) AS src
	, description
FROM
	public.geometry_columns AS gc
LEFT JOIN pg_description ON
	objoid = concat(gc.f_table_schema, '.', gc.f_table_name)::regclass
	AND objsubid = 0
ORDER BY
	gc.f_table_schema
	, gc.f_table_name;

Here is the SQL request I've created that returns description for each relation. Just in case somebody like me needs this!

[Guts]

cc @igeofr maybe it could interests you somehow since you're playing with pg comments