position指定字段长度+函数处理导入
最近更新时间: 2025-02-18 16:02:00
postgres=# \! cat /data/tbase/t_position_copy.txt
123阿弟2020010120200101121212
postgres=# copy t_position_copy (f1 position(1:3),f2 position(4:9) ,f3 position(10:17) to_date($3,'yyyymmdd'),f4 position(18:31) to_timestamp($4,'yyyymmddhh24miss')) from '/data/tbase/t_position_copy.txt';
COPY 1