SQL: Difference between revisions
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.
- sql Overview of SQL in GRASS
- databaseintro - Database management
- Using Openoffice.org with SQL Databases
- 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 SQL Reserved Words Checker to quickly find out if a name is reserved)