Re: date format
| От | David G. Johnston |
|---|---|
| Тема | Re: date format |
| Дата | |
| Msg-id | CAKFQuwa6mQaHigAZpcwTTA5RTTnB3yZfpJZnriJdbVDHOK5Eeg@mail.gmail.com обсуждение исходный текст |
| Ответ на | date format (Marc Millas <marc.millas@mokadb.com>) |
| Ответы |
Re: date format
|
| Список | pgsql-general |
On Wed, Jun 14, 2023 at 9:42 AM Marc Millas <marc.millas@mokadb.com> wrote:
Hi,I would like to load data from a file via file_fdw or COPY.. its a postgres 14 clusterbut.. 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.
В списке pgsql-general по дате отправления: