EXPDP TABLE

Function

EXPDP TABLE exports all table-related index, sequence, partition, toast, and toast index files.

Syntax

EXPDP TABLE table_name LOCATION = 'directory';

Parameter Description

• table_name

  Name of the table to be exported.

• directory

  Directory for storing exported files.

Examples

-- The EXPDP TABLE syntax is used for fine-grained backup and restoration and is called by the backup and restoration tool. If you directly call the syntax, an error message may be displayed, indicating that the directory does not exist. Therefore, you are not advised to directly call the syntax.
gaussdb=# EXPDP TABLE test_t LOCATION = '/data1/expdp/table0';