Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group