[GRASSLIST:5337] Re: GRASSRGB size, datatype and use

[Markus Neteler]

On Wed, Jan 12, 2005 at 03:10:08PM +0100, Moritz Lennert wrote:
> On Tue, January 11, 2005 18:38, DrakeGis said:
> > Hi,
> >   Thanks for the information about "d.vect.area" that now is "d.vect -a".
> > I still have a couple of questions. I would like to know what datatype
> > should be the GRASSRGB column. I'm used text, but I receive a warning
> > concerning to the length of the field, should it be varchar(11) ? How
> > can I specify that using db.execute ? is correct to use:
> >
> > echo "ALTER TABLE table_t ADD COLUMN grassrgb text(11)" | db.execute
> 
> I don't know. Have you tried ;-)

Try this:

 echo "ALTER TABLE table_t ADD COLUMN grassrgb varchar(11)" | db.execute
                                               ^^^^^^^^

Markus