Re: [GENERAL] COPY with composite type column

2007-12-26 Thread Reg Me Please
Il Wednesday 26 December 2007 14:31:04 Reg Me Please ha scritto: > Il Wednesday 26 December 2007 12:58:34 Reg Me Please ha scritto: > > Hi all. > > > > I have this composite type: > > > > create type ct as ( > > ct1 text, > > ct2 int > > ); > > > > Then I have this table > > > > create table at

Re: [GENERAL] COPY with composite type column

2007-12-26 Thread Reg Me Please
Il Wednesday 26 December 2007 12:58:34 Reg Me Please ha scritto: > Hi all. > > I have this composite type: > > create type ct as ( > ct1 text, > ct2 int > ); > > Then I have this table > > create table atable ( > somedata numeric, > otherdata text, > compo ct > ); > > when I try to COPY d

[GENERAL] COPY with composite type column

2007-12-26 Thread Reg Me Please
Hi all. I have this composite type: create type ct as ( ct1 text, ct2 int ); Then I have this table create table atable ( somedata numeric, otherdata text, compo ct ); when I try to COPY data to that table and use the following "query" I get a syntax error message: COPY atable( some