Re: COPY to table with array columns (Longish)

From: "Aaron Bono" <postgresql(at)aranya(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: COPY to table with array columns (Longish)
Date: 2006-06-13 04:11:43
Message-ID: bf05e51c0606122111m78e56216p3f0515cb5885fe1f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I think two tables should suffice: ZKCOST and ZPRECMPL.

So you would have

ZKCOST
zkcost_id,
zkcost_value

and

ZPRECMPL
zkcost_id,
zprecmpl_id,
zprecmpl_value

where zkcost_id is the primary key for ZKCOST and zkcost_id,
zprecmpl_id together are the primary key for ZPRECMPL and zkcost_id is
a foreign key from ZPRECMPL to ZKCOST.

That will work won't it?

-Aaron

On 6/12/06, Phillip Smith <phillips(at)weatherbeeta(dot)com(dot)au> wrote:

> So you're suggesting creating a child table for each SYS record? Ie, a table called "ZPRECMPL" etc?

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Phillip Smith 2006-06-13 05:29:35 Re: COPY to table with array columns (Longish)
Previous Message Richard Broersma Jr 2006-06-13 03:51:20 Re: COPY to table with array columns (Longish)