QGIS style should not require manual update for database name

[rustprooflabs]

What version of PgOSM Flex are you using?

0.7.1

Docker image

ebe9e07cef76

What did you do exactly?

Followed instructions for external Postgres connections, using a database name other than pgosm. I loaded the processed data into QGIS, specifically osm.road_line.

What did you expect to happen?

I expected the osm.road_line data to be styled since that is one of the styles I regularly expect to be there.

What did happen instead?

Loading the osm.road_line table into QGIS resulted in an unstyled layer. The style is there, I can manually load it from Postgres via the QGIS dialog, but that isn't ideal.

What did you do to try analyzing the problem?

This step is documented on https://pgosm-flex.com/qgis-styles.html

UPDATE public.layer_styles_staging
    SET f_table_catalog = 'your_db',
        f_table_schema = 'osm'
;

This should not be required as a manual operation. The process in Docker has all the details necessary to run the update command currently documented here

Overall, that QGIS style page is quite outdated now that I look at it. Needs some overall cleaning, review, and removing the manual step.