On this page

Show all

Help Center/ GaussDB(DWS)/ FAQs/ Database Usage/ How Do I View Foreign Table Information?

How Do I View Foreign Table Information?

Updated on 2023-11-21 GMT+08:00

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');

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback