Re: Erro

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
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:32:22
Message-ID: 20040503222914.Y26988@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, 28 Apr 2004, [iso-8859-1] Aldrey Galindo wrote:

> Hi,
> Would like to report a problem that happened with a
> friend mine. I was to inquire and I found the
> following one.
>
> --
> db=# create table teste (desc varchar(50));
> ERROR: parser: parse error at or near "desc" at
> character 21
> db=# create table table (teste varchar(50));
> ERROR: parser: parse error at or near "table" at
> character 14

DESC and TABLE are reserved words in SQL, so you need to double
quote them to use them as column or table names.

In response to

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

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-05-04 05:55:23 Re: [GENERAL] cache lookup of relation 165058647 failed
Previous Message Sean Chittenden 2004-05-04 05:19:08 Re: [GENERAL] cache lookup of relation 165058647 failed