RaigorJiang opened a new issue, #17979: URL: https://github.com/apache/shardingsphere/issues/17979
## Feature Request ### Is your feature request related to a problem? Yes. Now we have a RAL DistSQL `REFRESH TABLE METADATA`, which helps users to refresh the metadata of the specified logical table. In this syntax, users can also specify which resource to get the metadata from, for example: `REFRESH TABLE METADATA t_order FROM resource ds_1;` However, in the PostgreSQL series of databases, tables can also be distributed in different schemas. Therefore, the current syntax cannot satisfy the scenario of PostgreSQL non-public schema. ### Describe the feature you would like. I would like to add a parameter to `REFRESH TABLE METADATA` that allows users to specify the schema, which is an optional parameter. I think the syntax might be like this: `REFRESH TABLE METADATA tableName FROM RESOURCE resourceName SCHEMA schemaName;` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
