damn.. thanks Marc MILLAS Senior Architect +33607850334 www.mokadb.com
On Thu, Jun 11, 2020 at 8:55 PM Paul Ramsey <pram...@cleverelephant.ca> wrote: > ALTER TABLE "regions-20180101" rename to regions_20180101; > > > > On Jun 11, 2020, at 11:54 AM, Marc Millas <marc.mil...@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 > > > >
