Loading Array data from delimited ascii files
От | Jim Jennis |
---|---|
Тема | Loading Array data from delimited ascii files |
Дата | |
Msg-id | 35F68676.6E5D@imation.com обсуждение исходный текст |
Ответы |
Re: [SQL] Loading Array data from delimited ascii files
|
Список | 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@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! ----------------------------------------------------------------- -- 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-sql по дате отправления: