Subject Re: AW: [firebird-support] Is there a utility which will convert FB to Postgres
Author Helen Borrie
At 02:49 PM 28/09/2004 +0200, you wrote:
>Hi
>
>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.

CHARACTER VARYING is legal syntax in Firebird.

> replace TEXT with some BLOB, refer to IB 6 beta documentation for exact
>type.

TEXT is legal syntax in Firebird, preceded by BLOB SUB_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
>
>
>
>