luhuayi 85562e1879 DWS UMN 831.100 version

Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: luhuayi <luhuayi@huawei.com>
Co-committed-by: luhuayi <luhuayi@huawei.com>

2024-11-13 08:55:54 +00:00

How Do I View GaussDB(DWS) Foreign Table Information?

To query information about OBS/GDS foreign tables such as OBS paths, run the following statement:

1
SELECT * FROM pg_get_tabledef ('foreign_table_name')

The following uses table traffic_data.GCJL_OBS as an example:

1
SELECT * FROM pg_get_tabledef('traffic_data.GCJL_OBS');

Parent topic: Database Usage