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 <[email protected]> wrote: > > > On Fri, Sep 6, 2019 at 5:48 AM <[email protected]> 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 > > >
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
