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:58:28 |
Message-ID: | 50358034.5000903@boscorama.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 08/22/12 17:41, Mike Christensen wrote:
> 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?
Hmm. with a little sed or awk you could convert them into CSV for copy. Or
you could even just use copy with the '^' as delimiter and massage the tables
afterwards.
There is also pgloader which may help. I haven't used it but it gets mentioned
here quite a lot.
>> The alternative would be to download the Excel version, then Save as
>> CSV, and import into Postgres via the COPY command.
That's the lowest effort course you have, I think.
> 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.
mdb-tools? <http://mdbtools.sourceforge.net/>
Not sure if it's up to date.
There are a few other things mentioned here (some links no longer work :-( ) :
<http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#Microsoft_Access>
Bosco.
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2012-08-23 01:13:31 | Re: NULL value comparison |
Previous Message | John R Pierce | 2012-08-23 00:58:19 | Re: What text format is this and can I import it into Postgres? |