|
I'm using PostgreSQL 8.3.1.
I've created the following composite
type:
CREATE TYPE expression_event_type AS (
event_id varchar(10), expr_indices smallint[] ); which is used with the following table
definition:
CREATE TABLE boolean_expr_table(
expr_id smallint PRIMARY KEY, expr_name varchar(100) NOT NULL, _expression_ varchar(256) NOT NULL, event_indices expression_event_type[] NOT NULL, true_cases smallint[] NOT NULL ); Question: What is the correct way to load the
event_indices column using the copy command and a external file?
I've tried: {(1,{1,2,3})} without
success.
|