Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1phhLe-0005Vy-6t for pgsql-general@arkaria.postgresql.org; Thu, 30 Mar 2023 01:45:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1phhLc-0001QO-TE for pgsql-general@arkaria.postgresql.org; Thu, 30 Mar 2023 01:45:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1phhLc-0001QF-Gw for pgsql-general@lists.postgresql.org; Thu, 30 Mar 2023 01:45:04 +0000 Received: from mail-yw1-x1136.google.com ([2607:f8b0:4864:20::1136]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1phhLZ-0002kV-BD for pgsql-general@lists.postgresql.org; Thu, 30 Mar 2023 01:45:03 +0000 Received: by mail-yw1-x1136.google.com with SMTP id 00721157ae682-5416698e889so328445087b3.2 for ; Wed, 29 Mar 2023 18:45:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; t=1680140699; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=ewJ9a1vDaLnH3q6fXl+bSCQzgcKAO65HNiE+FTLFpog=; b=KrNPa/WQjkivt0i6rcvsX0JLeWQg9+HVdt1aT8epO6pMT/N4qWxBPKvrA/by4fT5AK ZMj1j+MIIesT5KsznmS/vGfgoCUBKIMC+8afFkcOPNRSYPjTMZl58CU232g5G3M3wFL6 cxqJXsh+vGyCLtI9bHkvaWjWgJUKIKhd6Oh2sCdHM9t3NKX5SNaFxZQX6Pdu0lk6KzA1 xm2qAItykKaEL8TbYPj5cbVH0eM6u10jSv3NK0ydtWMf9oYEQViLtz9dc5/48M7fzc6l 3cx+XAR4pbPgj559dTKaFXqdj3tItq6SFI40tHO08sXDpYbSsai8OSSTQnBFZlFNcgxL UC1Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1680140699; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=ewJ9a1vDaLnH3q6fXl+bSCQzgcKAO65HNiE+FTLFpog=; b=AijkM8BZssk1ZiFup5x8FRIL4UbsqxBN+9WOCYHT5G50Y1TPL3UpX/ki05QpZY9IjB V+xZeLPcIHcV4BZ3cLv7hsklB6H+mDNC6BoTkavq5fqsz1AFD+efKgwcYlcHiV1x8XyS dJfgJN/6K8U2Oz9awZ8Pjx5MmGwKGPribcTxtQfr2p2z9X7TrlBSjcOoF9Sdg7nKKm3T 7VXdW5243PJAmsgtOi5g8nB9OfTHKx0xqy1DDT9srstAgxA37L2W8FRM7BJG1AmUaSwP zliEg+EfkZaJkc5Vrvhx7eAHOCf75Ro6wtLJn9PQT72lB7+oQp4yU1cvsbmgCfDmzlGO u5Fg== X-Gm-Message-State: AAQBX9cmsGXZWyO6SvRYQo+CNKof4HRTM4Z2JgQyDodgRQcXDgVVCDCV mft+a+Ae7IK5w0kzcSEiPjByQqn99OU= X-Google-Smtp-Source: AKy350YxfQVlyj9/lGVvRZZMYpdlNXej0cm7uNl0d38acDTpjfpy0C7doMKtfAIy7UYt540nFOaWWQ== X-Received: by 2002:a81:7444:0:b0:544:c7a1:875b with SMTP id p65-20020a817444000000b00544c7a1875bmr20962973ywc.24.1680140698916; Wed, 29 Mar 2023 18:44:58 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:54b1:168a:9c6e:c2e4? ([2600:1700:bd2c:b810:54b1:168a:9c6e:c2e4]) by smtp.googlemail.com with ESMTPSA id 73-20020a810d4c000000b00545a08184a5sm3284600ywn.53.2023.03.29.18.44.58 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 29 Mar 2023 18:44:58 -0700 (PDT) Message-ID: <79caca69-54c5-1129-fa35-94c4a07b5608@gmail.com> Date: Wed, 29 Mar 2023 20:44:56 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.8.0 Subject: Re: COPY and custom datestyles. Or some other technique? Content-Language: en-US To: pgsql-general@lists.postgresql.org References: <906ddad7-43a9-b9bd-e75b-fae24ed5d3fa@evolvis.org> From: Ron In-Reply-To: <906ddad7-43a9-b9bd-e75b-fae24ed5d3fa@evolvis.org> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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.