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 "-00-00 00:00:00" in mysql.
Select on the forei
d by the FDW to manage this point ?
-Message d'origine-
De : Adrian Klaver
Envoyé : vendredi 23 mars 2018 13:52
À : Patricia DECHANDOL ;
pgsql-general@lists.postgresql.org
Objet : Re: Use pgloader with FDW
On 03/23/2018 03:55 AM, Patricia DECHANDOL wrote:
> Hello,
>
>
Thanks a lot Adrian.
We can't update the mysql columns values, so I will adopt the datetime -> text
solution.
Thanks again
-Message d'origine-
De : Adrian Klaver
Envoyé : vendredi 23 mars 2018 14:25
À : Patricia DECHANDOL ;
pgsql-general@lists.postgresql.org
Objet : Re:
nvoyé : vendredi 23 mars 2018 14:58
À : Patricia DECHANDOL
Cc : Adrian Klaver ;
pgsql-general@lists.postgresql.org
Objet : Re: Use pgloader with FDW
I suppose MySQL has the concept of views. Perhaps you can create a view over
the table that translates those 0-datetimes to NULL and have the FDW connect to
