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. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly