[GRASS-user] RE: Problem querying layers other than '1' in gi s.m

[Moritz Lennert]

On Mon, September 25, 2006 18:13, Patton, Eric wrote:
> I tried renaming within sqlitebrowser to no avail. I posted the error
> within
> my message a few posts ago. I'm unfamiliar with a lot of the SQL syntax,
> but
> I tried:
>
> ALTER TABLE  Video_Benthos
> RENAME Rumbolt_Video_Benthos_Uncorrected_UTC_NR.ID ID ;
>
> But I'm most likely getting the syntax incorrect. Any ideas?

ALTER TABLE  Video_Benthos RENAME
Rumbolt_Video_Benthos_Uncorrected_UTC_NR.ID ID ;

I'm not sure sqlite supports renaming a column.

http://www.sqlite.org/lang_altertable.html

Doesn't mention the possibility.

In Postgresql the query would have to be

ALTER TABLE  Video_Benthos RENAME
Rumbolt_Video_Benthos_Uncorrected_UTC_NR.ID TO ID ;

i.e. you have to add the 'TO'.

Moritz