EXPDP TABLE

Description

Exports all table-related index, sequence, partition, TOAST, and TOAST index files.

Syntax

EXPDP TABLE table_name LOCATION = 'directory';

Parameters

• 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 call it directly, the error message "ERROR: Only auxdb is allowed to execute expdp cmd." is displayed.
gaussdb=# EXPDP TABLE test_t LOCATION = '/data1/expdp/table0';