Re: table name

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
>