On 08/22/12 17:41, Mike Christensen wrote: > On Wed, Aug 22, 2012 at 5:38 PM, Mike Christensen <mike@xxxxxxxxxxxxx> wrote: >> On Wed, Aug 22, 2012 at 5:34 PM, Bosco Rama <postgres@xxxxxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
