How Do I View Foreign Table Information?¶
To query information about OBS/GDS foreign tables such as OBS paths, run the following statement:
SELECT * FROM pg_get_tabledef ('foreign_table_name')
The following uses table traffic_data.GCJL_OBS as an example:
SELECT * FROM pg_get_tabledef('traffic_data.GCJL_OBS');
