How to import data from MDB or pipe delimited file into PostgreSQL - Mailing list pgsql-general

From PostgreSQL
Subject How to import data from MDB or pipe delimited file into PostgreSQL
Date
Msg-id 001701bf0c54$766ffc60$0300000a@cpqivx-2
Whole thread Raw
Responses Re: [GENERAL] How to import data from MDB or pipe delimited file into PostgreSQL
List pgsql-general
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* ?

With mSQL it is easy, it has already a builtin function where you specify
the name of the text file you are importing, the database and table to input
the data, which character should be treated as a separator (comma, pipe,
etc.).

TIA,
Paulo



pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] alpha and true64 port
Next
From: "Jackson, DeJuan"
Date:
Subject: testing unsubscribe