[Pgsql-ayuda] long binary - long varchar

necesito convertir algunos tipos de datos en los archivos de LOG para poder hacer el transpaso de la informacion

el problema de algunos TIPOS de DATOS como sigue
en este archivo de LOG que me da el PB,
creo q tb puedo agregarles ya los PRIMARY KEY y los FOREING KEY

en Sybase tengo los TYPOS DE DATOS

LONG BINARY que utilizan para guardar figuras
LONG VARCHAR

// en PowerBuilder haciendo un
// Object Export Sintax to Log a la tabla domicilios
// usando ODBC del Sybase produce:

CREATE TABLE domicilios
(numero_interno integer NOT NULL,
legajo integer NOT NULL,
calle varchar(40) ,
telefono varchar(40) ,
barrio varchar(40) ,
ciudad integer NOT NULL,
pais integer NOT NULL,
croquis long binary ,
tipo_domicilio char(1) NOT NULL,
fecha_referencia date NOT NULL) ;

// y sigue con los index's y CIA..
============= ======= ============

// ahora lo mismo
// usando ODBC del PostgreSQL produce:

CREATE TABLE "domicilios"
("numero_interno" int4 NOT NULL,
"legajo" int4 NOT NULL,
"calle" varchar(40) ,
"telefono" varchar(40) ,
"barrio" varchar(40) ,
"ciudad" int4 NOT NULL,
"pais" int4 NOT NULL,
"croquis" lo ,
"tipo_domicilio" varchar(1) NOT NULL,
"fecha_referencia" date NOT NULL) ;

CREATE INDEX "domicilios_i1"
ON "domicilios"
("legajo" ,
"fecha_referencia" ) ;

insert into pbcattbl
(pbt_tnam,
pbt_ownr,
pbd_fhgt,
pbd_fwgt,
pbd_fitl,
pbd_funl,
pbd_fchr,
pbd_fptc,
pbd_ffce,
pbh_fhgt,
pbh_fwgt,
pbh_fitl,
pbh_funl,
pbh_fchr,
pbh_fptc,
pbh_ffce,
pbl_fhgt,
pbl_fwgt,
pbl_fitl,
pbl_funl,
pbl_fchr,
pbl_fptc,
pbl_ffce,
pbt_cmnt)
values
('domicilios',
'sal',
-10,
400,
'N',
'N',
0,
34,
'Arial',
-10,
700,
'N',
'N',
0,
34,
'Arial',
-10,
400 ,
'Y',
'N',
0,
34,
'Arial',
'') ;

insert into pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_init)
values
('domicilios',
'sal',
'numero_interno',
'Número Interno:',
23 ,
'Número Interno',
25,
23 ,
26 ,
0 ,
0 ,
'N',
'autoincrement' ) ;

insert into pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_edit )
values
('domicilios',
'sal',
'legajo',
'Legajo:',
23 ,
'Legajo',
25,
23 ,
26 ,
0 ,
0 ,
'N',
'em_integer' ) ;

insert into pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_edit )
values
('domicilios',
'sal',
'calle',
'Calle:',
23 ,
'Calle',
25,
23 ,
27 ,
0 ,
0 ,
'N',
'Descripción 40' ) ;

insert into pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_edit )
values
('domicilios',
'sal',
'telefono',
'Teléfono:',
23 ,
'Teléfono',
25,
23 ,
27 ,
0 ,
0 ,
'N',
'Descripción 40' ) ;

insert into pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_edit )
values
('domicilios',
'sal',
'barrio',
'Barrio:',
23 ,
'Barrio',
25,
23 ,
27 ,
0 ,
0 ,
'N',
'Descripción 40' ) ;

insert into pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_edit )
values
('domicilios',
'sal',
'ciudad',
'Ciudad:',
23 ,
'Ciudad',
25,
23 ,
26 ,
0 ,
0 ,
'N',
'em_integer' ) ;

insert into pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_edit )
values
('domicilios',
'sal',
'pais',
'País:',
23 ,
'País',
25,
23 ,
26 ,
0 ,
0 ,
'N',
'em_smallint' ) ;

insert into pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap)
values
('domicilios',
'sal',
'croquis',
'Croquis:',
23 ,
'Croquis',
25,
23 ,
26 ,
0 ,
0 ,
'N') ;

insert into pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_init,
pbc_edit )
values
('domicilios',
'sal',
'tipo_domicilio',
'Tipo Domicilio:',
23 ,
'Tipo Domicilio',
25,
23 ,
27 ,
0 ,
0 ,
'N',
'O' ,
'es_tipo_domicilio' ) ;

insert into pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_edit )
values
('domicilios',
'sal',
'fecha_referencia',
'Fecha Referencia:',
23 ,
'Fecha Referencia',
25,
23 ,
26 ,
0 ,
0 ,
'N',
'em_fechas' ) ;

____________________________________________________
Sandrigo Lezcano Jara Asunción, Paraguay
usando______: Ret Hat 7.2 (Enigma) - Kernel 2.4.7-10
PostgreSQL 7.1.3 - psqlODBC 7.02.00.01
migrando____: Sybase 6.5 al PostgreSQL
front end___: PowerBuilder 6.5
==================ICQ:143590717=====================
____________________________________________________