John R Pierce wrote on 16.03.2009 00:41:
Greenhorn wrote:
Unfortunately When I execute the above files using \i I am getting
errors like
ERROR: syntax error at or near "("
LINE 4: SUB_TYPE NUMBER(3) NOT NULL,
Obviously 'number' is not PostgreSQL data type so is 'varchar2'. What
is your suggestion to create these tables in PostgreSQL? Should I
pre-process using Sed/Awk to find/replace the field type first? Any
recommendation is greatly appreciated :)
change number to numeric, and varchar2 to char and you'll likely be good.
My guess would have been that varchar is the equivalent to varchar2
char does a blank padding and is different in behaviour to varchar (as it is in
Oracle)
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
