Re: [GENERAL] How to import data from MDB or pipe delimited file into PostgreSQL - Mailing list pgsql-general

Not long ago, PostgreSQL proclaimed...
> What is the best way to import into a PostgreSQL database data from a
> Microsoft Access database?
>
> Should I export the data to a pipe or comma delimited file and then import?
> *But how can I do that* ?

Once you have an Access table exported using some kind of delimiter, use
the COPY command to import it into a table in PostgreSQL.

psql> COPY INTO TABLE1 FROM '/home/joe/access_export.csv' USING
      USING DELIMITER ',';

I'm not aware of any way to import table schemas from Access- you'll
probably still have to do that by hand.

-=Fozz

--
Doran L. Barton <fozz@iodynamics.com>
Iodynamics LLC -- "Internetworking the masses"
<URL:http://www.iodynamics.com/>