db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Dudziak" <tom...@gmail.com>
Subject Re: Booleans and converter(Subelement)
Date Thu, 14 Dec 2006 05:15:19 GMT
On 12/13/06, Laurent ROCHE <laurent_roche@yahoo.com> wrote:

> I am moving a PostgreSQL db into a Derby db, using the Ant tasks.
>
> As I have boolean columns in my PG db (and that there's none in Derby) I have done a
search and replace in the generated schema.xml file (from PG), to replace all BOOLEAN by SMALLINT.
> That works fine but reading the doc I realise there's a converter subelement to go from
one type to another.
>
> But that's for data. Is there something equivalent for the schema ?
> Or does that do the transformation on the schema too ?

DdlUtils will take care of that, simply leave the schema as it is.
DdlUtils will use the most appropriate native type that the database
has to offer.

Tom

Mime
View raw message