Обсуждение: Arrays and COPY FROM: Help!!!

Hi!

I'm now using PostgreSQL for a few months now and I need to use arrays
in some tables of my database. I've read some documentation about using
arrays with PostgreSQL, but I still don't how I can perform a 'COPY
FROM' to insert large number of records : of course inserted records
should contain multidimensionnal fields... Who does know the way to do
it ???

Thank you for advance.

PS: I hope my question is clear enough... Sorry for my poor English ;-((

On Thu, Apr 05, 2001 at 04:31:57PM +0200, Laurent MARTIN wrote:
> Hi!
>
> I'm now using PostgreSQL for a few months now and I need to use arrays
> in some tables of my database. I've read some documentation about using
> arrays with PostgreSQL, but I still don't how I can perform a 'COPY
> FROM' to insert large number of records : of course inserted records
> should contain multidimensionnal fields... Who does know the way to do
> it ???
>
> Thank you for advance.

CREATE TABLE twodim (array integer[2][2]);
COPY twodim FROM stdin USING DELIMITERS '|';
{{1,2},{3,4}}
{{4,3},{2,1}}
\.

The level of nesting of braces "{}" indicates the dimensions of the
array.  1-dim {} , 2-dim {{},{}}, etc.

--
Eric G. Miller <egm2@jps.net>