LucidDbCreateForeignTable

From Eigenpedia

Syntax

CREATE FOREIGN TABLE qualified-table-name
[ ( foreign-column-definition, ... ) ]
SERVER server_name 
[ OPTIONS ( storage-option, ... ) ] 
[ DESCRIPTION table-description ]

foreign-column-definition ::= 
unqualified-column-name
data-type
[ NOT NULL ]
[ OPTIONS ( storage-option, ... ) ]

storage-option ::= option-name 'option-value-as-literal-string'

See LucidDbDataTypes for specification of data-type.

Example

CREATE FOREIGN TABLE staging.customer_stage (
    name VARCHAR(128) NOT NULL,
    dnb_number VARCHAR(50),
    industry VARCHAR(50),
    revenue NUMERIC(8))
SERVER file_dump_staging
OPTIONS (filename 'customer_dump');

-- equivalent if columns can be inferred from file structure
SET SCHEMA 'STAGING';
CREATE FOREIGN TABLE customer_stage
SERVER file_dump_staging
OPTIONS (filename 'customer_dump');

Additional Resources

• Design documentation on the JDBC foreign data wrapper (including documentation of OPTIONS).
• Specifications for flat file foreign data access