Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id D8034475A3F
	for <pgsql-sql@postgresql.org>; Mon, 11 Nov 2002 09:57:31 -0500 (EST)
Received: from hotmail.com (f51.pav1.hotmail.com [64.4.31.51])
	by postgresql.org (Postfix) with ESMTP id 3626C47580B
	for <pgsql-sql@postgresql.org>; Mon, 11 Nov 2002 09:57:31 -0500 (EST)
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	Mon, 11 Nov 2002 06:57:35 -0800
Received: from 193.136.224.3 by pv1fd.pav1.hotmail.msn.com with HTTP;
	Mon, 11 Nov 2002 14:57:34 GMT
X-Originating-IP: [193.136.224.3]
From: "Carlos Sousa" <carlosdsousa@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: bigger problem
Date: Mon, 11 Nov 2002 14:57:34 +0000
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Message-ID: <F51Y1R1ybSyGE5oHKoF00002df8@hotmail.com>
X-OriginalArrivalTime: 11 Nov 2002 14:57:35.0039 (UTC)
	FILETIME=[AB34CCF0:01C28992]
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200211/163
X-Sequence-Number: 10305

in postgres database i created a table with a field like

create table (...)
(...)
var text default '' not null
(...)

now i need to import the data from this table into a oracle database
i used pg_dump

I altered the field data type to

(...)
var varchar2(50) default '' not null
(...)

but when i was importing the the table into the oracle database all the rows 
with the field var='' were not inserted.
Is there a way to work this around

thanks for your time and replay





_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*. 
http://join.msn.com/?page=features/featuredemail