Re: Erro - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Erro
Date
Msg-id 29851.1083647200@sss.pgh.pa.us
Whole thread Raw
In response to Erro  (Aldrey Galindo <aldreygalindo@yahoo.com.br>)
List pgsql-bugs
Aldrey Galindo <aldreygalindo@yahoo.com.br> writes:
> db=# create table teste (desc varchar(50));
> ERROR:  parser: parse error at or near "desc" at
> character 21

DESC is a reserved keyword, per the SQL specification.

If you really really want to name your column or table "desc", you can
double-quote the word.  But I'd suggest picking another name.
        regards, tom lane


pgsql-bugs by date:

Previous
From: Sean Chittenden
Date:
Subject: Re: [GENERAL] cache lookup of relation 165058647 failed
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] cache lookup of relation 165058647 failed