Subject | Re: AW: [firebird-support] Is there a utility which will convert FB to Postgres |
---|---|
Author | Helen Borrie |
Post date | 2004-09-28T13:27:18Z |
At 02:49 PM 28/09/2004 +0200, you wrote:
i.e. create table blah (
id integer not null,
memo BLOB SUB_TYPE TEXT,
title CHARACTER VARYING(40),
.......
./heLen
>HiCHARACTER VARYING is legal syntax in Firebird.
>
>You can use most of this in firebird directly.
>Propably the only changes:
> replace VARYING with some VARCHAR(xxx) with xxx high enough for your
>needs.
> replace TEXT with some BLOB, refer to IB 6 beta documentation for exactTEXT is legal syntax in Firebird, preceded by BLOB SUB_TYPE
>type.
i.e. create table blah (
id integer not null,
memo BLOB SUB_TYPE TEXT,
title CHARACTER VARYING(40),
.......
./heLen
>However, if you have a windows station connected to the original database
>with odbc, try using IBDataPump.
>
>Regards,
> Steffen
>
>
>[Non-text portions of this message have been removed]
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>