bigger problem

Поиск
Список
Период
Сортировка
От Carlos Sousa
Тема bigger problem
Дата
Msg-id F51Y1R1ybSyGE5oHKoF00002df8@hotmail.com
обсуждение исходный текст
Ответы Re: bigger problem  ("Josh Berkus" <josh@agliodbs.com>)
Re: bigger problem  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-sql
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



В списке pgsql-sql по дате отправления:

Предыдущее
От: dima
Дата:
Сообщение: Re: small problem
Следующее
От: Christoph Haller
Дата:
Сообщение: Re: Generating a cross tab (pivot table)