Re: What text format is this and can I import it into Postgres?

From: Bosco Rama <postgres(at)boscorama(dot)com>
To: Mike Christensen <mike(at)kitchenpc(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: What text format is this and can I import it into Postgres?
Date: 2012-08-23 00:34:36
Message-ID: 50357A9C.2060501@boscorama.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2012-08-23 00:35:08 Re: What text format is this and can I import it into Postgres?
Previous Message Rob Sargent 2012-08-23 00:33:10 Re: What text format is this and can I import it into Postgres?