Help Center/ Data Warehouse Service / Developer Guide/ Developer Guide (9.1.1.x)/ DWS System Catalogs and Views/ System Views/ PGXC_GET_TABLESPACE_OBS_FILE

Updated on 2025-10-10 GMT+08:00

View PDF

PGXC_GET_TABLESPACE_OBS_FILE

The PGXC_GET_TABLESPACE_OBS_FILE view is used to obtain all files of the PG_DB_FILE system catalog in the previous tablespace of the current cluster. This view is supported only by clusters of version 9.1.1.100 or later.

**Table 1** PGXC_GET_TABLESPACE_OBS_FILE columns
Column	Type	Description
node_name	name	Node name
db_oid	oid	Database OID
table_space_oid	oid	Tablespace OID
relfilenode	oid	Physical directory ID of the table
file_id	bigint	File ID
file_type	text	File type
file_size	bigint	File size in bytes
file_path	text	Absolute path of the file

Parent Topic: System Views

Previous topic: PGXC_GET_TABLE_SKEWNESS

Next topic: PGXC_GLOBAL_TEMP_ATTACHED_PIDS

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.