[postgis-users] breake lines

[Martin Davis]

To be more concrete. the 'id' column in the example is a proxy for the full
set of attribute columns in the data table.  So wherever 'id' appears in a
SELECT list you will need to substitute the full set of required columns.

On Fri, Sep 6, 2019 at 10:37 AM Martin Davis <mtnclimb at gmail.com> wrote:

>
>
> On Fri, Sep 6, 2019 at 5:48 AM <paul.malm at lfv.se> wrote:
>
>> Hi, I’ve succeeded in creating the table as you suggested Martin
>> (Thanks!). With some small modifications (CollectionExtract etc.)
>>
>> The problem is that I would like to transfer all attributes from the
>> original file to the result file. I’ve tried so many ways but I can’t get
>> it right.
>>
>>
>>
> You'll probably have to name all the attribute columns you want to keep in
> the SELECT list.
>
> This would be easier & more reusable if Postgres supported SELECT * EXCEPT
> ( ...) (a la H2 [1])
>
> [1] https://h2database.com/html/grammar.html#wildcard_expression
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190906/94956f85/attachment.html>