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.