pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jim Jennis <jhjennis@imation.com>
To: pgsql-sql@postgresql.org
Subject: Loading Array data from delimited ascii files
Date: Wed, 09 Sep 1998 09:45:26 -0400
Message-ID: <35F68676.6E5D@imation.com> (raw)

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!
-----------------------------------------------------------------



view thread (2+ messages)  latest in thread

Message-ID: <35F68676.6E5D@imation.com>
Permalink:  ../35F68676.6E5D@imation.com/
Also on:    postgresql.org/message-id/35F68676.6E5D@imation.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: jhjennis@imation.com
  Subject: Re: Loading Array data from delimited ascii files
  In-Reply-To: <35F68676.6E5D@imation.com>
  References: <35F68676.6E5D@imation.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox