| From: | Mike Christensen <mike(at)kitchenpc(dot)com> |
|---|---|
| To: | Bosco Rama <postgres(at)boscorama(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:38:48 |
| Message-ID: | CABs1bs12p1bBVV=NdZcLJLd5yPMaXHYtPVJ7ohbD0oGngpiq8A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
Mike
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Johnston | 2012-08-23 00:40:18 | Re: What text format is this and can I import it into Postgres? |
| Previous Message | Rob Sargent | 2012-08-23 00:35:08 | Re: What text format is this and can I import it into Postgres? |