云数据库 GaussDB-file_fdw:示例

时间:2025-02-12 14:55:58

示例

--创建server。gaussdb=# CREATE SERVER file_server FOREIGN DATA WRAPPER file_fdw;CREATE SERVER--创建外表。gaussdb=# CREATE FOREIGN TABLE file_ft(id int, name text) SERVER file_server OPTIONS(filename '/tmp/1.csv', format 'csv', delimiter ',');CREATE FOREIGN TABLE--删除外表。gaussdb=# DROP FOREIGN TABLE file_ft;DROP FOREIGN TABLE--删除server。gaussdb=# DROP SERVER file_server;DROP SERVER
support.huaweicloud.com/fg-gaussdb-cent/gaussdb-48-0246.html