Re: bigger problem

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: "Carlos Sousa" <carlosdsousa(at)hotmail(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: bigger problem
Date: 2002-11-11 18:13:29
Message-ID: web-1821180@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Carlos,

> 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

This is a problem with your configuration of Oracle import. See your
Oracle documentation; we cannot help you here.

-Josh Berkus

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2002-11-11 18:27:59 Re: Generating a cross tab (pivot table)
Previous Message Josh Berkus 2002-11-11 17:59:56 Re: Permission on insert rules