vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/dws/umn/dws_03_2124.html
Lu, Huayi c5fcb46315 DWS UMN 801 version 
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2022-12-13 12:47:57 +00:00

2.3 KiB
Raw Permalink Blame History

How Do I View 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