Re: table name

damn..
thanks

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com

On Thu, Jun 11, 2020 at 8:55 PM Paul Ramsey <pramsey(at)cleverelephant(dot)ca>
wrote:

> ALTER TABLE "regions-20180101" rename to regions_20180101;
>
>
> > On Jun 11, 2020, at 11:54 AM, Marc Millas <marc(dot)millas(at)mokadb(dot)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
> >
>
>