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

On Wed, Aug 22, 2012 at 5:38 PM, Mike Christensen <mike(at)kitchenpc(dot)com> wrote:
> On Wed, Aug 22, 2012 at 5:34 PM, Bosco Rama <postgres(at)boscorama(dot)com> wrote:
>> 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)
>
> Okay so is there a way to import "Relational Files" into Postgres?
>
> The alternative would be to download the Excel version, then Save as
> CSV, and import into Postgres via the COPY command.

Oh, also if anyone knows of a way to export an Access database to
Postgres, that might be helpful. I don't have a copy of Access.