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
