Skip site navigation (1) Skip section navigation (2)

copy command and array of composite types?

From: "Jon Norman" <jnorman(at)alumni(dot)utexas(dot)net>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: copy command and array of composite types?
Date: 2008-03-25 18:19:41
Message-ID: 004d01c88ea4$cc9e0d30$820b010a@normanm90 (view raw or flat)
Thread:
Lists: pgsql-sql
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. 

Responses

pgsql-sql by date

Next:From: Guy FraserDate: 2008-03-25 20:12:21
Subject: Re: copy command and array of composite types?
Previous:From: Tom LaneDate: 2008-03-25 15:07:38
Subject: Re: Deferrable NOT NULL REFERENCES ... for two-way referential relationship

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group