sql component can not replace pgsql schema or tablename parameter

[hangliu1994]

When i use a parameter in sql component to replace pgsql schema,It will indicate that it cannot be replaced.

The following image is my script：

The following image is log:

How to replace pgsql schema param? Please help me

[hangliu1994]

@710700

[Tandoy]

Maybe try this ${schema}

SELECT count(1) from ${schema}.wh$wh_official_account_follow_cnt_bd;

[hangliu1994]

Please tell me which datasource you choose?
When I use mysql ,it is effective, but postgresql is not effective.

[hangliu1994]

My dolphinscheduler release is 2.0.3

[Tandoy]

My dolphinscheduler release is 2.0.3

The data source is also postgresql, but the version is 1.3.6, I will try the new version later for experiments

[hangliu1994]

My dolphinscheduler release is 2.0.3

The data source is also postgresql, but the version is 1.3.6, I will try the new version later for experiments

Thank you for your help