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
umns 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: Use pgloa
een the MySQL
database and the Postgres one and do the transformation in real time. AFAIK
that is not possible.
>
>
>
> -Message d'origine-
> De : Adrian Klaver Envoyé : vendredi 23
> mars 2018 13:52 À : Patricia DECHANDOL ;
> pgsql-general@lists.postgresql.org
&g
rmation in real time. AFAIK that is not possible.
-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,
I
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,
>
>
On 03/23/2018 03:55 AM, Patricia DECHANDOL wrote:
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 valu
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
