Using a delimited Ascii File to initialize fields and array elements in bulk - Mailing list pgsql-general

From Jim Jennis
Subject Using a delimited Ascii File to initialize fields and array elements in bulk
Date
Msg-id 35F68489.372D@imation.com
Whole thread Raw
List pgsql-general
Hello Fellow Postgres Users!

I am converting a large document database to postgresql. I have modified
a table to convert a pair of integer fields in the old database
(notebook_number, copy_number) into a 2 dimensional array which pairs
one field with the other. After dumping all the data into a flat "|"
delimited ascii file, I want to bulk load it into my new table.

psql complains that I need to specify array indicies when I try to do a
copy using the ascii file as input.

What is the proper syntax for storing array points from an ascii file?

TIA for your help!
--
Regards,

Jim Jennis, Senior Specialist/Manufacturing & Information Technology
Imation Corp.
Printing & Publishing Systems
Systems/Networking/Internet Services
200 Brucetown Road
Kearneysville, WV. 25430 USA.
Internet: jhjennis@imation.com

------<OpenVMS!--When it Absolutely Positively HAS to Run!>
------<Linux!--The Choice of the "GNU" Generation!-------->
------<NT?--In Manufacturing translate "Not Today"!-------->
 Disclaimer:
 My opinions belong to me!
 Any similarities between my personal views
 and the corporate views or policies of
 Imation are purely coincidental!
-----------------------------------------------------------------

pgsql-general by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: [GENERAL] Is there any sample "ready-to-use" database files?
Next
From: Andrea Antibo
Date:
Subject: primary key