Re: COPY and custom datestyles. Or some other technique?

Поиск
Список
Период
Сортировка
От Ron
Тема Re: COPY and custom datestyles. Or some other technique?
Дата
Msg-id 79caca69-54c5-1129-fa35-94c4a07b5608@gmail.com
обсуждение исходный текст
Ответ на Re: COPY and custom datestyles. Or some other technique?  (Thorsten Glaser <tg@evolvis.org>)
Список pgsql-general
On 3/29/23 19:20, Thorsten Glaser wrote:
> On Wed, 29 Mar 2023, Ron wrote:
>
>> There are 550+ tables, so something that I can do once on this end would make
>> my life a lot easier.
> Some quick perl or awk or shell job to batch-change the field
> to an accepted syntax is probably quicker.

Even easier would be to create views on the source which cast from DATE VMS 
to TIMESTAMP(2).

Whatever the method, it all added up to lots places where I can make an 
error or overlook something.

-- 
Born in Arizona, moved to Babylonia.



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

Предыдущее
От: Thorsten Glaser
Дата:
Сообщение: Re: COPY and custom datestyles. Or some other technique?
Следующее
От: Ron
Дата:
Сообщение: Re: COPY and custom datestyles. Or some other technique?