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