Re: COPY table_name (single_column) FROM 'iso-8859-1.txt' DELIMITER E'\n'

Поиск
Список
Период
Сортировка
От Joel Jacobson
Тема Re: COPY table_name (single_column) FROM 'iso-8859-1.txt' DELIMITER E'\n'
Дата
Msg-id 0e451c85-ce2c-4197-91aa-5eecd4f0d3e9@www.fastmail.com
обсуждение исходный текст
Ответ на Re: COPY table_name (single_column) FROM 'iso-8859-1.txt' DELIMITER E'\n'  ("Daniel Verite" <daniel@manitou-mail.org>)
Список pgsql-hackers
Дерево обсуждения
What about:

   COPY ... FROM ... WITH PATTERN 'regexp_pattern'

Where the columns would be matched with the capture groups.

This could handle the quite common case of varying white-space as column separators:

   COPY log (col1, col2, col3) FROM 'log.txt' WITH PATTERN '^(\S+)\s+(\S+)\s+(\S+)$'

This could also handle $SUBJECT:

   COPY table_name (single_column) FROM 'unknown.txt' WITH PATTERN '^(.*)$';

And lots of other more complex use-cases.

/Joel

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Another modest proposal for reducing CLOBBER_CACHE_ALWAYS runtime
Следующее
От: Peter Smith
Дата:
Сообщение: Re: AlterSubscription_refresh "wrconn" wrong variable?