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

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: COPY and custom datestyles. Or some other technique?
Date: 2023-03-30 01:44:56
Message-ID: 79caca69-54c5-1129-fa35-94c4a07b5608@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2023-03-30 01:50:57 Re: COPY and custom datestyles. Or some other technique?
Previous Message Thorsten Glaser 2023-03-30 00:20:49 Re: COPY and custom datestyles. Or some other technique?