I can port the "normalize table name", "normalize column name" to the old
postgis writer. Can be done before or after migration. Not a blocking feature
---
** [bugs:#469] Postgres: Save Dataset Adds Quotation Marks**
**Status:** open
**Milestone:**
**Labels:** postgis dataset
**Created:** Wed Apr 11, 2018 04:09 AM UTC by John L. Poole
**Last Updated:** Wed Apr 11, 2018 06:54 AM UTC
**Owner:** nobody
When I perform a File -Save Dataset As => Save to PostGIS Table, select the
radio "Cread new or replace..." the table that is creates has column names
wrapped with double quotation marks.
This was very confusing as when I tried to perform some queries, I kept getting
column not found and then I realized I had to include quotation marks around
the column name.
So this works:
~~~
select distinct("MAINTENANC"), count(*)
from kimselect
group by "MAINTENANC"
order by "MAINTENANC"
~~~
whereas this fails:
~~~
select distinct(MAINTENANC), count(*)
from kimselect
group by MAINTENANC
order by MAINTENANC
~~~
I should like to be able to create a table that matches the attributes/features
name without having to include quotation marks.
---
Sent from sourceforge.net because jump-pilot-devel@lists.sourceforge.net is
subscribed to https://sourceforge.net/p/jump-pilot/bugs/
To unsubscribe from further messages, a project admin can change settings at
https://sourceforge.net/p/jump-pilot/admin/bugs/options. Or, if this is a
mailing list, you can unsubscribe from the mailing list._______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
