Hi,

I can't find the way to make something that should be really usual :

I want to import some values in a table of a postgresql database. This table is very simple except the fact that one of its column have a specific type : "type_entite". This is a type i declared in postgres like an enum of ('E','L','M').

In TOS, when i retrieve the table schema with the metadata manger, TOS maps my specific type with a generic type : String.

Well, it doen't really matter to me but the point is that when i try to import my datas (my source is a delimited file) in the table, i get this error :

ERROR: column "code_entite" is of type type_entite but expression is of type character varying

It seems that it tries to convert from string to type_entite but as TOS doesn't know what is type_entite, it crashes. So, my question is : Is there a way to retrieve my personal db types from my database, in order to use them in TOS ?

Regards,

etletisme.

Last edited by etletisme (2009-04-23 17:56:45)