Re: Problem in creating a table

Wen Guangcheng wrote:
> Hi Gurus,
>
> When I try to create a table by a script I get a error as follows,
> #####################################################
> [postgres@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,
                  ^^^^^^^^
I don't think there is a varchar2.

>     AC_COUNT    NUMBER(6,0)               DEFAULT 0,
>     PRIMARY KEY("AC_YEAR","AC_MONTH","AC_DAYS","OFFICE_ID")

If you're going to quote names, ALWAYS quote them, otherwise let PG fold
them to lower-case.

--
  Richard Huxton
  Archonet Ltd