Hi, Just tried the following with PostgreSQL and table was created. I do not know if it works with all versions and I agree that using spaces in table names is not a brilliant idea.
CREATE TABLE "test space" as select * from table limit 1; -Jukka- edgar.sol...@web.de wrote: > On 10.04.2013 13:41, Uwe Dalluege wrote: > > Hi, > > > > Am 10.04.2013 11:27, schrieb edgar.sol...@web.de: > >> On 10.04.2013 11:15, Uwe Dalluege wrote: > >>> Hi, > >>> > >>> is it possible to change the > >>> default Layer Name of > >>> "Run Datastore Query" > >>> to a valid SQL table name? > >>> > >>> An inexperienced user with SQL > >>> maybe do not know that > >>> "New Query Layer" is not a valid > >>> layername (SQL-Tablename). > >>> > >> > >> i'd rather suggest to check & hint so on trying to save the table so > >> user can rename manually then. because 1. user has a learning effect > >> then > > > > I do not think, that OJ should be a try and error GIS only for a > > learning effect. > > how do you suppose a db user will learn about naming restrictions then? > > > > > > >> 2. the name is proper in OJ and not all db's have the same naming > >> conventions > > > > > > Please tell me a databasemanagementsystem which uses standard SQL and > > accept blanks inside the tablename. > > why do you expect every DBMS connector to use ANSI SQL? there are > several SQL dialects out there and used actively as well. > MYSQL for one supports spaces in table names. > > ..ede > > ------------------------------------------------------------------------------ > Precog is a next-generation analytics platform capable of advanced analytics > on semi-structured data. The platform includes APIs for building apps and a > phenomenal toolset for data science. Developers can use our toolset for > easy data analysis & visualization. Get a free account! > http://www2.precog.com/precogplatform/slashdotnewsletter > _______________________________________________ > Jump-pilot-devel mailing list > Jump-pilot-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel ------------------------------------------------------------------------------ Precog is a next-generation analytics platform capable of advanced analytics on semi-structured data. The platform includes APIs for building apps and a phenomenal toolset for data science. Developers can use our toolset for easy data analysis & visualization. Get a free account! http://www2.precog.com/precogplatform/slashdotnewsletter _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
