-- afficher la liste des tables et les éléments de compréhension :
WITH table_list AS (
   SELECT  table_schema, table_name FROM  information_schema.tables WHERE  table_schema='sysma'

)
, comment_table_liste as (
  SELECT  table_schema, table_name ,
    xx_99_utils.f_rtn_table_comment(
	    table_schema::NAME,
	    table_name::NAME) as t_comment
	    FROM table_list order by table_name

    )
, comment_table_liste_json_format AS (
    SELECT * 
    , CASE 
    WHEN t_comment ilike '{%' THEN t_comment::json 
    ELSE '{
   "display_groupe_order":0,
   "groupe_name":"groupe_name A DEFINIR",
   "table_comment":"table_comment A DEFINIR"
}'::json
    END::json as comment_json
      from comment_table_liste
      )
    
    ,aff as (
	select -- 'aff' as aff_type 
    
    (comment_json::json->>'groupe_name')::text AS groupe_name 
	--, table_schema
	, table_name 
    , (comment_json::json->>'table_comment')::text AS comment_table
	, (comment_json::json->>'display_groupe_order')::numeric as display_groupe_order
    
    from comment_table_liste_json_format
    order by (comment_json::json->>'display_groupe_order')::numeric asc
    , table_name asc
    )
, markdown as (
   select 'markdown format'::text as groupe_name 
   , null::name table_name
   , '| Type de table | Nom de la table | Commentaire |
| ------ | ------ | ------ | ' || string_agg ( '
| ' || groupe_name || ' | ' || table_name || ' | ' || comment_table, '') as comment_table
	, 9999999::numeric as display_groupe_order
	FROM aff --order by aff.display_groupe_order
  )		
	
 SELECT * FROM aff
   UNION ALL
 SELECT * FROM markdown
 ORDER BY display_groupe_order, table_name