On Wed, 2023-06-14 at 20:02 +0200, Marc Millas wrote:
> So, creating a foreign table with varchar type, and then doing the insert as select with the appropriate format..
clear.
> somewhat sad as it was a one step process with the former oracle db we get rid off.
It can be a one-step process, if you create a view on the table that uses
to_date() to convert the column to a "date".
Yours,
Laurenz Albe