[GRASSLIST:3759] Re: db.execute

Radim Blazek blazek at itc.it
Mon Jun 28 03:25:50 EDT 2004


On Saturday 26 June 2004 20:45, Markus Neteler wrote:
> > > but db.execute statements fail, e.g.:
> > > echo 'create table test_table ("cat" int, "desc" text)' | db.execute
> >
> > 'text' is not supported by DBF, column names should not be quoted, try
> > echo 'create table test_table (cat int, desc varchar(50))' | db.execute
>
> Also this suggestion fails (also the command given in the man page):
>
> echo 'create table test_table (cat int, desc varchar(50))' | db.execute
> DBMI-Postgres driver error:
> Cannot execute:
> create table test_table (cat int, desc varchar(50))
>
> ERROR:  parser: parse error at or near "desc" at character 35
> WARNING: Error while executing: "create table test_table (cat int, desc
>          varchar(50))
>          "

'desc' is SQL reserved key word.

Radim




More information about the grass-user mailing list