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
