LOAD SINGLE TABLE

Description

The LOAD SINGLE TABLE syntax is used to load single table from storage unit.

Syntax

Grammar Railroad diagram

  1. loadSingleTable ::=
  2.   'LOAD' 'SINGLE' 'TABLE' tableDefinition
  4. tableDefinition ::=
  5.   tableIdentifier (',' tableIdentifier)*
  7. tableIdentifier ::=
  8.   '*.*' | '*.*.*' | storageUnitName '.*' | storageUnitName '.*.*' | storageUnitName '.' schemaName '.*' | storageUnitName '.' tableName | storageUnitName '.' schemaName '.' tableName
  10. storageUnitName ::=
  11.   identifier
  13. schemaName ::=
  14.   identifier
  16. tableName ::=
  17.   identifier

Supplement

  • support specifying schemaName in PostgreSQL and OpenGauss protocols

Example

  • Load specified single table
  1. LOAD SINGLE TABLE ds_0.t_single;
  • Load all single tables in the specified storage unit
  1. LOAD SINGLE TABLE ds_0.*;
  • Load all single tables
  1. LOAD SINGLE TABLE *.*;

Reserved word

LOAD, SINGLE, TABLE