Hi Marc,
> On 11. Jun, 2020, at 20:54, Marc Millas <marc(dot)millas(at)mokadb(dot)com> wrote:
> sorry if my question is tooo simple :-)
it's not. :-)
> obviously if I ask:
> select * from regions-20180101;
> I get a syntax error.
> if I try select * from $$regions_20180101$$;
> I get another syntax error.
> If I try to rename that table, same thing.
> if I try a cte, same thing.
>
> What should I do ?
you can just quote its name:
select * from "regions-20180101";
Cheers,
Paul