Received: from mta1.imation.com (mail2.imation.com [207.242.212.8]) by hub.org (8.8.8/8.7.5) with SMTP id JAA14564 for ; Wed, 9 Sep 1998 09:45:49 -0400 (EDT) Received: from jim-jennis.imation.com ([163.228.104.77]) by mta1.imation.com (Lotus SMTP MTA Internal build v4.6.2 (651.2 6-10-1998)) with SMTP id 8625667A.004B97CB; Wed, 9 Sep 1998 08:45:40 -0500 Message-ID: <35F68676.6E5D@imation.com> Date: Wed, 09 Sep 1998 09:45:26 -0400 From: Jim Jennis Reply-To: jhjennis@imation.com Organization: Imation Corp. X-Mailer: Mozilla 3.01Gold (Win95; I) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Loading Array data from delimited ascii files Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello Fellow Postgres Users! Sorry..posted this to the general list by mistake! 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 ------ ------ ------ Disclaimer: My opinions belong to me! Any similarities between my personal views and the corporate views or policies of Imation are purely coincidental! ----------------------------------------------------------------- -- 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 ------ ------ ------ Disclaimer: My opinions belong to me! Any similarities between my personal views and the corporate views or policies of Imation are purely coincidental! -----------------------------------------------------------------