Re: Importing an ASCII file

Поиск
Список
Период
Сортировка
От jik@foxinternet.net
Тема Re: Importing an ASCII file
Дата
Msg-id 3B97C89D.6F519E1B@foxinternet.net
обсуждение исходный текст
Ответ на Importing an ASCII file  (Francisco Reyes <lists@natserv.com>)
Список pgsql-novice
Francisco Reyes wrote:
>
> I have an ASCII file with fields separated by tabs.
> My only issue is that text fields are enclosed with "
> Is there a way to tell Postgresql to ignore those "?
> Mean time I am going to try and take out the " using one of the Unix
> tools.
>
> Didn't see anything on the FAQ on importing data from ASCII files. Isn't
> this an FAQ?

Couldn't you pipe it through tr?

В списке pgsql-novice по дате отправления:

Предыдущее
От: Francisco Reyes
Дата:
Сообщение: Importing an ASCII file
Следующее
От: David Mulcahy
Дата:
Сообщение: pl/pgsql function problem