Retro Eye care Haitian Deep Dark Default

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 ::=
  identifier

Supplement

  • 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