Rainer Klute <[EMAIL PROTECTED]> writes: > Here's an Oracle example:
> create table BUSINESS_PROCESS > (ID NUMBER not null primary key, > BUSINESS_PROTOCOL varchar2(254), > PROTOCOL_VERSION varchar2(254), > DEFAULT_CONVERSATION_TIMEOUT NUMBER); Oh, just another nonstandard datatype name then. You could use CREATE DOMAIN to create NUMBER as an alias for integer (or bigint or numeric, depending on what range of values you're expecting). varchar2 is harder since we don't have any provision for precision options on domains. You'll pretty much have to search-and-replace that to varchar in your schema file :-( regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly