Problem in creating a table

From: "Wen Guangcheng" <wen(at)microcourt(dot)co(dot)jp>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Problem in creating a table
Date: 2005-05-17 06:47:55
Message-ID: 001c01c55aac$5eafa010$2908a8c0@office.jsys.fukuokau.ac.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Gurus,

When I try to create a table by a script I get a error as follows,
#####################################################
[postgres(at)demo pgsql]$ psql -d postgres -e -f /opt/rapisa/sql/TD_ACCESSCOUNT.sql

CREATE TABLE TD_ACCESSCOUNT(
AC_YEAR NUMBER(4,0) NOT NULL,
AC_MONTH NUMBER(2,0) NOT NULL,
AC_DAYS NUMBER(2,0) NOT NULL,
OFFICE_ID VARCHAR2(7) NOT NULL,
AC_COUNT NUMBER(6,0) DEFAULT 0,
PRIMARY KEY("AC_YEAR","AC_MONTH","AC_DAYS","OFFICE_ID")
)
TABLESPACE RAPIS;
psql:/opt/rapisa/sql/TD_ACCESSCOUNT.sql:14: ERROR: syntax error at or near "(" at character 52
#####################################################

I really don't know what is wrong with it and do appreciate it if anyone would
point out it. The version of Postgresql is 7.4.7.
Thanks in advance.

--Wen

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-05-17 07:16:00 Re: Problem in creating a table
Previous Message MLikharev 2005-05-17 00:18:16 CREATE TEMP TABLE AS SELECT/ GET DIAGNOSTICS ROW_COUNT