table name

From: Marc Millas <marc(dot)millas(at)mokadb(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: table name
Date: 2020-06-11 18:54:55
Message-ID: CADX_1aaMDjae0L_MHbfUhnqYnUZCFVFaEZdUSGNr1o0JK4hN3A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Ramsey 2020-06-11 18:55:55 Re: table name
Previous Message Chris Stephens 2020-06-11 18:27:57 ansible modules for postgresql installation/config