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.
pgsql-sql by date:
Соглашаюсь с условиями обработки персональных данных