On 08/22/12 17:23, Mike Christensen wrote: > I'd like to import this data into a Postgres database: > > http://www.ars.usda.gov/SP2UserFiles/Place/12354500/Data/SR24/dnload/sr24.zip > > However, I'm not quite sure what format this is. It's definitely not > CSV. Here's an example of a few rows: > > ~01001~^~0100~^~Butter, salted~^~BUTTER,WITH > SALT~^~~^~~^~Y~^~~^0^~~^6.38^4.27^8.79^3.87
<http://www.ars.usda.gov/SP2UserFiles/Place/12354500/Data/SR24/sr24_doc.pdf> Section "Relation Files" (Logical page 25) HTH Bosco. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
