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 1phf9n-0005fF-BK for pgsql-general@arkaria.postgresql.org; Wed, 29 Mar 2023 23:24:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1phf9l-0003Vg-EU for pgsql-general@arkaria.postgresql.org; Wed, 29 Mar 2023 23:24:41 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1phf9l-0003VX-2E for pgsql-general@lists.postgresql.org; Wed, 29 Mar 2023 23:24:41 +0000 Received: from mail-oi1-x236.google.com ([2607:f8b0:4864:20::236]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1phf9i-0003oa-O9 for pgsql-general@lists.postgresql.org; Wed, 29 Mar 2023 23:24:40 +0000 Received: by mail-oi1-x236.google.com with SMTP id l18so12895525oic.13 for ; Wed, 29 Mar 2023 16:24:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; t=1680132278; h=content-transfer-encoding:subject:from:content-language:to :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=O7PKjVnTefOcCC4+6QmWELWblhX2R0DjabSNXszAG5o=; b=F96ELJ4YyfCDMh9s1Sld1Fvx/HI5LVcIx8jmWDRNfOsrAkcKDKQuSYURTpIyvWOzWh hF4MXrwIf4hHewoeYVfIcnV1P2/h5US/PBJ2G57HwNPSJgliHEzH1F8BiJezxxMbMfXD LVGwCRE4QF/qsMT8gSh766hOCk7S5chnFM/s8G2o5soBCyJsV6uB4JbRPAzsE0iGJGY/ wn3uEOjmkEHGKbyhhDXstBG0lXe/iCTbN4AxwB8QwBQWPQQ9sRamF1FWLft1xJRrjRcs ++sa32dEUtB6+O3vh2hqAcRibjYjAwlWiS7fKcDMhR4V8HnoMG+xGqVWF1H4pVJ79Oci vRiQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1680132278; h=content-transfer-encoding:subject:from:content-language:to :user-agent:mime-version:date:message-id:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=O7PKjVnTefOcCC4+6QmWELWblhX2R0DjabSNXszAG5o=; b=fka7HD0LO8YXF9AiiDcT1pHAuaLkJPt0QW3lz3GnWwVwdDOPY8eTERPyIY9FwSLy/R OHlqoUtQd08q2irpsSu6wEbkpEANSMtZGzT9f0+IK4Y9vyJPwLkLUVpMp2vOVdqHA0AC 1x/LA1xE6kd/6wqTdnpcSuYGCUOBQWX6Ttqzp7sVUTbIUJkh420YqzVmbwjfQD8GTr5l 0TAzDEloX4Wpgo0Il/MGxgbh3rYDoxkk4UXdBt/DDJoBZt8jx9ZiGFwPAD69D1bavnm5 /6zB6vsxQx/xWtL689gWLIyS0Sdf4M45Fifj4PP0Bwg93UwIquJ+3MmDGQPeXpzDpOd5 IpHw== X-Gm-Message-State: AAQBX9cjWFp4XLipHnBXDDiR+I2SxFfWL9p+v1D3V4mE3Xu0XtUIdnTO yKBlj6Tr/0osY4/nuB2YAXTGflRKVdc= X-Google-Smtp-Source: AKy350Y19ihQHEmbpoKQBqISDgvnwuNOxgmPLUH/jZsXDvZPqGN3RtqQTDB0ZRtQUcaoYhMy+aMltA== X-Received: by 2002:a54:400a:0:b0:389:9c8:7747 with SMTP id x10-20020a54400a000000b0038909c87747mr6755185oie.21.1680132277791; Wed, 29 Mar 2023 16:24:37 -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 p1-20020a4a95c1000000b0053e8336f5dcsm359697ooi.7.2023.03.29.16.24.37 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 29 Mar 2023 16:24:37 -0700 (PDT) Message-ID: Date: Wed, 29 Mar 2023 18:24:36 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.8.0 To: pgsql-general@lists.postgresql.org Content-Language: en-US From: Ron Subject: COPY and custom datestyles. Or some other technique? Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Postgresql 13.10 $ psql -h myhost.example.com -X dba \         -c "\copy ${tbl} from '/var/lib/pgsql/Rdb/${tbl}.csv' WITH DELIMITER '|';" ERROR:  date/time field value out of range: "2013061914122501" CONTEXT:  COPY t_id_master, line 1, column update_timestamp: "2013061914122501" The timestamp format generated by a legacy dbms is YYYYMMDDHHmmSSCC (year to centisecond, with no delimiters). Is there any way to convince Postgresql to import these fields? There are 550+ tables, so something that I can do once on this end would make my life a lot easier. -- Born in Arizona, moved to Babylonia.