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
