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.


View raw message