Re: date format
От
Adrian Klaver
Тема
Re: date format
Дата
Msg-id
3e806c01-a445-79a9-62b7-80a29a1b99eb@aklaver.com
Ответ на
Re: date format (Marc Millas)
Список
Дерево обсуждения
date format Marc Millas <marc.millas@mokadb.com>
Re: date format "David G. Johnston" <david.g.johnston@gmail.com>
Re: date format Marc Millas <marc.millas@mokadb.com>
Re: date format Ron <ronljohnsonjr@gmail.com>
Re: date format Marc Millas <marc.millas@mokadb.com>
Re: date format Adrian Klaver <adrian.klaver@aklaver.com>
Re: date format Marc Millas <marc.millas@mokadb.com>
Re: date format Laurenz Albe <laurenz.albe@cybertec.at>
Re: date format Michael Nolan <htfoot@gmail.com>
On 6/14/23 11:23, Marc Millas wrote: > > Sort of like?: https://pgloader.readthedocs.io/en/latest/ref/csv.html date format column-name [date format 'YYYY-MM-DD HH24-MI-SS.US'] > > > In Postgresql, could you write a simple anonymous procedure that > reads the file_fdw table records, does the conversion and then > inserts into the destination table? > -> one sql line insert as select using the to_date() function with > appropriate format. > > -- > Born in Arizona, moved to Babylonia. > -- Adrian Klaver adrian.klaver@aklaver.com
В списке pgsql-general по дате отправления
