Hello,
I’m new to Postgresql and try to use the FDW with mysql database.
Everything is OK to create my FDW and foreign tables, but I meet a problem when I try to do a select on a FOREIGN table containing datetime column which contains the value “0000-00-00 00:00:00” in mysql.
Select on the foreign table fails.
The mysql datetime column has been automatically wrapped to “timestamp without timezone” column in the foreign table by the instruction “import foreign schema” that I used.
How can I deal with this ?
I read about the pgloader with can manage this king of problem, but can’t figure out how to use it with FDW.
Thanks for your help.