LOAD SINGLE TABLE
Description
The LOAD SINGLE TABLE syntax is used to load single table from storage unit.
Syntax
loadSingleTable ::=
'LOAD' 'SINGLE' 'TABLE' tableDefinition
tableDefinition ::=
tableIdentifier (',' tableIdentifier)*
tableIdentifier ::=
'*.*' | '*.*.*' | storageUnitName '.*' | storageUnitName '.*.*' | storageUnitName '.' schemaName '.*' | storageUnitName '.' tableName | storageUnitName '.' schemaName '.' tableName
storageUnitName ::=
identifier
schemaName ::=
identifier
tableName ::=
identifierSupplement
- support specifying schemaName in PostgreSQL and OpenGauss protocols
Example
- Load specified single table
LOAD SINGLE TABLE ds_0.t_single;- Load all single tables in the specified storage unit
LOAD SINGLE TABLE ds_0.*;- Load all single tables
LOAD SINGLE TABLE *.*;Reserved word
LOAD, SINGLE, TABLE