ALTER TABLE "regions-20180101" rename to regions_20180101;
> On Jun 11, 2020, at 11:54 AM, Marc Millas <marc.millas@mokadb.com> wrote: > > sorry if my question is tooo simple :-) > > I got a shapefile from the french gov. > I import it with postgis 3.01 utility. > fine ! > the table created by this utility is named regions-20180101 > with the dash in the middle. > I see that table name in pg_class, and, also, in the geometry_columns view. > > > 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 ? > > thanks, > > > Marc MILLAS > Senior Architect > +33607850334 > www.mokadb.com >
