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

Поиск
Список
Период
Сортировка
От PostgreSQL
Тема How to import data from MDB or pipe delimited file into PostgreSQL
Дата
Msg-id 001701bf0c54$766ffc60$0300000a@cpqivx-2
обсуждение исходный текст
Ответы Re: [GENERAL] How to import data from MDB or pipe delimited file into PostgreSQL  ("Doran L. Barton" <fozz@iodynamics.com>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [GENERAL] alpha and true64 port
Следующее
От: "Jackson, DeJuan"
Дата:
Сообщение: testing unsubscribe