SQL: Difference between revisions

From GRASS-Wiki
Jump to navigation Jump to search
(fix man link)
(+Analysing SQL syntax errors/table import or copy problems)
Line 7: Line 7:
* Using [[Openoffice.org with SQL Databases]]
* Using [[Openoffice.org with SQL Databases]]
* [[SQL rename columns]]
* [[SQL rename columns]]
=== Analysing SQL syntax errors/table import or copy problems ===
Sometimes it happens that db.*, v.db.* or other SQL related commands fail. For example, with
  ERROR:  syntax error at or near "Offset"
  LINE 1: ...eatureDet varchar(254), Measure double precision, Offset dou...
                                                              ^
  WARNING: Unable to create table <hydro_pointEvent>
  WARNING: Copy table failed
How to fix that? Check out for
* column name used more than one time;
* column name has reserved SQL word (depends on DB backend, see [http://www.petefreitag.com/tools/sql_reserved_words_checker/ SQL Reserved Words Checker] to quickly find out if a name is reserved)


[[Category:FAQ]]
[[Category:FAQ]]

Revision as of 15:09, 17 March 2011

SQL support in GRASS GIS

GRASS 6 uses SQL for vector attribute management.


Analysing SQL syntax errors/table import or copy problems

Sometimes it happens that db.*, v.db.* or other SQL related commands fail. For example, with

 ERROR:  syntax error at or near "Offset"
 LINE 1: ...eatureDet varchar(254), Measure double precision, Offset dou...
                                                             ^
 WARNING: Unable to create table <hydro_pointEvent>
 WARNING: Copy table failed

How to fix that? Check out for

  • column name used more than one time;
  • column name has reserved SQL word (depends on DB backend, see SQL Reserved Words Checker to quickly find out if a name is reserved)