Re: Erro

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Aldrey Galindo <aldreygalindo(at)yahoo(dot)com(dot)br>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Erro
Date: 2004-05-04 05:06:40
Message-ID: 29851.1083647200@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

=?iso-8859-1?q?Aldrey=20Galindo?= <aldreygalindo(at)yahoo(dot)com(dot)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

In response to

  • Erro at 2004-04-28 19:51:32 from Aldrey Galindo

Browse pgsql-bugs by date

  From Date Subject
Next Message Sean Chittenden 2004-05-04 05:19:08 Re: [GENERAL] cache lookup of relation 165058647 failed
Previous Message Stephan Szabo 2004-05-03 20:45:28 Re: Query producing the wrong results?