syntax error with example sql of createtable

From: Honda Shigehiro <fwif0083(at)mb(dot)infoweb(dot)ne(dot)jp>
To: pgsql-docs(at)postgresql(dot)org
Subject: syntax error with example sql of createtable
Date: 2005-01-05 17:24:07
Message-ID: 20050106.022407.116372061.fwif0083@mb.infoweb.ne.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Hello,

I got a error when execute below command in
http://developer.postgresql.org/docs/postgres/sql-createtable.html

postgres=# CREATE TABLE array (vector int[][]);
ERROR: syntax error at or near "array" at character 14
LINE 1: CREATE TABLE array (vector int[][]);

^
(I tried it on 8.0.0rc2.)

'array' is a reserved word, so it needs quote to create table
named array:
postgres=# CREATE TABLE "array" (vector int[][]);
CREATE TABLE

regards,
-- Shigehiro Honda

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2005-01-05 18:03:26 Re: syntax error with example sql of createtable
Previous Message Peter Eisentraut 2005-01-04 21:38:05 man pages fixed