Re: [SQL] Loading Array data from delimited ascii files

On Wed, 9 Sep 1998, Jim Jennis wrote:

> Date: Wed, 09 Sep 1998 09:45:26 -0400
> From: Jim Jennis <jhjennis@imation.com>
> To: pgsql-sql@postgreSQL.org
> Subject: [SQL] Loading Array data from delimited ascii files
>
> 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?

Check the syntax for inserting array data into a table.  See the docs at:

http://www.postgresql.org/docs/user/arrays.htm

I think all the data that will go into your array field will need to be
contained within one set of delimiters, and you'll need to use the array
insertion syntax to specify your array between the delimiters.

I hope that makes sense/works...

eric

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

_______________________
Eric McKeown
ericm@palaver.net
http://www.palaver.net