From: | Jim Jennis <jhjennis(at)imation(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Loading Array data from delimited ascii files |
Date: | 1998-09-09 13:45:26 |
Message-ID: | 35F68676.6E5D@imation.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)imation(dot)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!
-----------------------------------------------------------------
--
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(at)imation(dot)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!
-----------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | John Palmer | 1998-09-09 16:03:31 | |
Previous Message | Vadim Mikheev | 1998-09-09 02:29:07 | Re: [SQL] SubQuery speed |