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
