Hi Marc, > On 11. Jun, 2020, at 20:54, Marc Millas <marc.millas@xxxxxxxxxx> 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
