Re: Oracle to PostgreSQL
От
John R Pierce
Тема
Re: Oracle to PostgreSQL
Дата
Msg-id
49BD9231.4010602@hogranch.com
Ответ на
Oracle to PostgreSQL (Greenhorn)
Список
Дерево обсуждения
Oracle to PostgreSQL Greenhorn <user.postgresql@gmail.com>
Re: [SQL] Oracle to PostgreSQL Marcin Stępnicki <mstepnicki@gmail.com>
Re: Oracle to PostgreSQL John R Pierce <pierce@hogranch.com>
Re: Oracle to PostgreSQL Thomas Kellerer <spam_eater@gmx.net>
Re: Oracle to PostgreSQL John R Pierce <pierce@hogranch.com>
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.
В списке pgsql-general по дате отправления
