Help Center/ Data Warehouse Service / FAQs/ Database Use/ How Do I View GaussDB(DWS) Foreign Table Information?
Updated on 2025-06-12 GMT+08:00
View PDF

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 Use