> On 11 Jun 2020, at 20:58, Paul Förster wrote:
>
> Hi Marc,
>
>> On 11. Jun, 2020, at 20:54, Marc Millas wrote:
>> sorry if my question is tooo simple :-)
>
> it's not. :-)
>
>> obviously if I ask:
>> select * from regions-20180101;
>> I get a syntax error.
>> if I try select * from $$regi
Hi Marc,
> On 11. Jun, 2020, at 20:54, Marc Millas wrote:
> sorry if my question is tooo simple :-)
it's not. :-)
> 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 tha
damn..
thanks
Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com
On Thu, Jun 11, 2020 at 8:55 PM Paul Ramsey
wrote:
> ALTER TABLE "regions-20180101" rename to regions_20180101;
>
>
> > On Jun 11, 2020, at 11:54 AM, Marc Millas
> wrote:
> >
> > sorry if my question is tooo simple :-)
>
ALTER TABLE "regions-20180101" rename to regions_20180101;
> On Jun 11, 2020, at 11:54 AM, Marc Millas 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 re
On Thursday, February 27, 2020, Guyren Howe wrote:
> # select
> *
> from
> unnest(array[array['a', 'b'], array['c', 'c']]),
> unnest(array[array['1', '2'], array['3', '4']]);
> ERROR: 42712: table name "unnest" specified more than once
>
This specific error is resolved by using the alias featu
