How to import data from MDB or pipe delimited file into PostgreSQL

From: "PostgreSQL" <pgsql(at)brazilinfo(dot)com>
To: "pgsql-general" <pgsql-general(at)postgreSQL(dot)org>
Subject: How to import data from MDB or pipe delimited file into PostgreSQL
Date: 1999-10-01 21:29:41
Message-ID: 001701bf0c54$766ffc60$0300000a@cpqivx-2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jackson, DeJuan 1999-10-01 22:27:41 testing unsubscribe
Previous Message Bruce Momjian 1999-10-01 20:14:54 Re: [GENERAL] alpha and true64 port