[GitHub] [shardingsphere] congzhou2603 commented on issue #25104: Shardingsphere support foreign table syntax for openGauss

["congzhou2603 (via GitHub)" <gi...@apache.org>]

congzhou2603 commented on issue #25104:
URL: https://github.com/apache/shardingsphere/issues/25104#issuecomment-1511011944

   Here is an exmaple for creating and dropping foreigin table.  “SERVER 'mot_server’” corresponeds to "SERVER gsmpp_server" in syntax, among which "gsmpp_server" indicates the server name of foreign table. "FOREIGN " and "SERVER gsmpp_server" both can be transparently transmitted to openGauss.
   ``` sql
   CREATE FOREIGN TABLE t_order (
   user_id int,
   order_name varchar(30),
   order_value varchar(50),
   order_id int default 0
   )
   SERVER mot_server;
   
   DROP FOREIGN TABLE t_order;
   ```


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org