On Wed, Jun 14, 2023 at 9:42 AM Marc Millas <marc.mil...@mokadb.com> wrote:
> Hi, > > I would like to load data from a file via file_fdw or COPY.. its a > postgres 14 cluster > > but.. One date (timestamp) column is written french order and another > column is written english order. Data comes from a state owned entity so > asking for a normalization may take ages. > > obviously I could load as char and then apply an appropriate > transformation. no pb. > But is there a direct way to do this ? > Probably no - casting formats via locale cannot be specified at that scope when using copy. Either the cast for a given single setting produces the correct result or it doesn't. If you need a custom cast like this you have to get away from COPY first. Usually that is best done after importing data to a temporary table as text. David J.
