[Pgsql-ayuda] long binary - long varchar
sandrigo lezcano
psql@msa.com.py
Fri, 23 May 2003 13:59:18 -0500
This is a multi-part message in MIME format.
------=_NextPart_000_001B_01C32133.80A8CA20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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,=20
creo q tb puedo agregarles ya los PRIMARY KEY y los FOREING KEY=20
en Sybase tengo los TYPOS DE DATOS
LONG BINARY que utilizan para guardar figuras=20
LONG VARCHAR =20
// en PowerBuilder haciendo un=20
// Object Export Sintax to Log a la tabla domicilios=20
// 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) ;
=20
// y sigue con los index's y CIA..
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=3D=3D =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
// 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) ;
=20
CREATE INDEX "domicilios_i1"
ON "domicilios"
("legajo" ,
"fecha_referencia" ) ;
=20
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',
'') ;
=20
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=FAmero Interno:',
23 ,
'N=FAmero Interno',
25,
23 ,
26 ,
0 ,
0 ,
'N',
'autoincrement' ) ;
=20
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' ) ;
=20
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=F3n 40' ) ;
=20
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=E9fono:',
23 ,
'Tel=E9fono',
25,
23 ,
27 ,
0 ,
0 ,
'N',
'Descripci=F3n 40' ) ;
=20
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=F3n 40' ) ;
=20
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' ) ;
=20
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=EDs:',
23 ,
'Pa=EDs',
25,
23 ,
26 ,
0 ,
0 ,
'N',
'em_smallint' ) ;
=20
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') ;
=20
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' ) ;
=20
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=F3n, Paraguay
usando______: Ret Hat 7.2 (Enigma) - Kernel 2.4.7-10=20
PostgreSQL 7.1.3 - psqlODBC 7.02.00.01
migrando____: Sybase 6.5 al PostgreSQL=20
front end___: PowerBuilder 6.5 =20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DICQ:143590717=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
____________________________________________________
------=_NextPart_000_001B_01C32133.80A8CA20
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2614.3500" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DCourier size=3D2>necesito convertir algunos tipos de =
datos en los=20
archivos de LOG para poder hacer el transpaso de la =
informacion</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DCourier size=3D2>el problema de algunos TIPOS de DATOS =
como=20
sigue</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2>en este archivo de LOG que me da el =
PB,=20
</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2>creo q tb puedo </FONT><FONT =
face=3DCourier=20
size=3D2>agregarles ya los PRIMARY KEY y los FOREING KEY </FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DCourier size=3D2>en Sybase tengo los TYPOS DE =
DATOS</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2></FONT> </DIV>
<DIV><FONT face=3DCourier size=3D2>LONG BINARY que =
utilizan para=20
guardar figuras </FONT></DIV>
<DIV><FONT face=3DCourier size=3D2>LONG VARCHAR =
</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DCourier size=3D2></FONT> </DIV>
<DIV><FONT face=3DCourier size=3D2>// en PowerBuilder haciendo un <BR>// =
Object=20
Export Sintax to Log a la tabla domicilios <BR>// usando ODBC del Sybase =
produce:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DCourier size=3D2>CREATE TABLE=20
domicilios<BR> (numero_interno =
integer NOT=20
NULL,<BR> legajo integer NOT=20
NULL,<BR> calle varchar(40)=20
,<BR> telefono varchar(40)=20
,<BR> barrio varchar(40)=20
,<BR> ciudad integer NOT=20
NULL,<BR> pais integer NOT=20
NULL,<BR> croquis long binary=20
,<BR> tipo_domicilio char(1) NOT=20
NULL,<BR> fecha_referencia date NOT =
NULL)=20
;<BR> <BR>// y sigue con los index's y =
CIA..<BR>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20
=3D=3D=3D=3D=3D=3D=3D =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DCourier size=3D2>// ahora lo mismo<BR>// usando ODBC =
del=20
PostgreSQL produce:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DCourier size=3D2>CREATE TABLE=20
"domicilios"<BR> =
("numero_interno"=20
int4 NOT NULL,<BR> "legajo" int4 NOT =
NULL,<BR> "calle" varchar(40)=20
,<BR> "telefono" varchar(40)=20
,<BR> "barrio" varchar(40)=20
,<BR> "ciudad" int4 NOT=20
NULL,<BR> "pais" int4 NOT=20
NULL,<BR> "croquis" lo=20
,<BR> "tipo_domicilio" varchar(1) =
NOT=20
NULL,<BR> "fecha_referencia" date =
NOT NULL)=20
;<BR> <BR>CREATE INDEX=20
"domicilios_i1"<BR> ON=20
"domicilios"<BR> ("legajo"=20
,<BR> "fecha_referencia" )=20
;<BR> <BR>insert into =
pbcattbl<BR> =20
(pbt_tnam,<BR> =20
pbt_ownr,<BR> =20
pbd_fhgt,<BR> =20
pbd_fwgt,<BR> =20
pbd_fitl,<BR> =20
pbd_funl,<BR> =20
pbd_fchr,<BR> =20
pbd_fptc,<BR> =20
pbd_ffce,<BR> =20
pbh_fhgt,<BR> =20
pbh_fwgt,<BR> =20
pbh_fitl,<BR> =20
pbh_funl,<BR> =20
pbh_fchr,<BR> =20
pbh_fptc,<BR> =20
pbh_ffce,<BR> =20
pbl_fhgt,<BR> =20
pbl_fwgt,<BR> =20
pbl_fitl,<BR> =20
pbl_funl,<BR> =20
pbl_fchr,<BR> =20
pbl_fptc,<BR> =20
pbl_ffce,<BR> =20
pbt_cmnt)<BR> =20
values<BR> =20
('domicilios',<BR> =20
'sal',<BR> =20
-10,<BR> =20
400,<BR> =20
'N',<BR> =20
'N',<BR> =20
0,<BR> =20
34,<BR> =20
'Arial',<BR> =20
-10,<BR> =20
700,<BR> =20
'N',<BR> =20
'N',<BR> =20
0,<BR> =20
34,<BR> =20
'Arial',<BR> =20
-10,<BR> 400=20
,<BR> =20
'Y',<BR> =20
'N',<BR> =20
0,<BR> =20
34,<BR> =20
'Arial',<BR> '') =
;<BR> <BR>insert=20
into pbcatcol<BR> =20
(pbc_tnam,<BR> =20
pbc_ownr,<BR> =20
pbc_cnam,<BR> =20
pbc_labl,<BR> =20
pbc_lpos,<BR> =20
pbc_hdr,<BR> =20
pbc_hpos,<BR> =20
pbc_jtfy,<BR> =20
pbc_case,<BR> =20
pbc_hght,<BR> =20
pbc_wdth,<BR> =20
pbc_bmap,<BR> =20
pbc_init)<BR> =20
values<BR> =20
('domicilios',<BR> =20
'sal',<BR> =20
'numero_interno',<BR> =
'N=FAmero=20
Interno:',<BR> 23=20
,<BR> 'N=FAmero=20
Interno',<BR> =20
25,<BR> 23=20
,<BR> 26=20
,<BR> 0=20
,<BR> 0=20
,<BR> =20
'N',<BR> 'autoincrement' )=20
;<BR> <BR>insert into =
pbcatcol<BR> =20
(pbc_tnam,<BR> =20
pbc_ownr,<BR> =20
pbc_cnam,<BR> =20
pbc_labl,<BR> =20
pbc_lpos,<BR> =20
pbc_hdr,<BR> =20
pbc_hpos,<BR> =20
pbc_jtfy,<BR> =20
pbc_case,<BR> =20
pbc_hght,<BR> =20
pbc_wdth,<BR> =20
pbc_bmap,<BR> pbc_edit=20
)<BR> =20
values<BR> =20
('domicilios',<BR> =20
'sal',<BR> =20
'legajo',<BR> =20
'Legajo:',<BR> 23=20
,<BR> =20
'Legajo',<BR> =20
25,<BR> 23=20
,<BR> 26=20
,<BR> 0=20
,<BR> 0=20
,<BR> =20
'N',<BR> 'em_integer' )=20
;<BR> <BR>insert into =
pbcatcol<BR> =20
(pbc_tnam,<BR> =20
pbc_ownr,<BR> =20
pbc_cnam,<BR> =20
pbc_labl,<BR> =20
pbc_lpos,<BR> =20
pbc_hdr,<BR> =20
pbc_hpos,<BR> =20
pbc_jtfy,<BR> =20
pbc_case,<BR> =20
pbc_hght,<BR> =20
pbc_wdth,<BR> =20
pbc_bmap,<BR> pbc_edit=20
)<BR> =20
values<BR> =20
('domicilios',<BR> =20
'sal',<BR> =20
'calle',<BR> =20
'Calle:',<BR> 23=20
,<BR> =20
'Calle',<BR> =20
25,<BR> 23=20
,<BR> 27=20
,<BR> 0=20
,<BR> 0=20
,<BR> =20
'N',<BR> 'Descripci=F3n 40' )=20
;<BR> <BR>insert into =
pbcatcol<BR> =20
(pbc_tnam,<BR> =20
pbc_ownr,<BR> =20
pbc_cnam,<BR> =20
pbc_labl,<BR> =20
pbc_lpos,<BR> =20
pbc_hdr,<BR> =20
pbc_hpos,<BR> =20
pbc_jtfy,<BR> =20
pbc_case,<BR> =20
pbc_hght,<BR> =20
pbc_wdth,<BR> =20
pbc_bmap,<BR> pbc_edit=20
)<BR> =20
values<BR> =20
('domicilios',<BR> =20
'sal',<BR> =20
'telefono',<BR> =20
'Tel=E9fono:',<BR> 23=20
,<BR> =20
'Tel=E9fono',<BR> =20
25,<BR> 23=20
,<BR> 27=20
,<BR> 0=20
,<BR> 0=20
,<BR> =20
'N',<BR> 'Descripci=F3n 40' )=20
;<BR> <BR>insert into =
pbcatcol<BR> =20
(pbc_tnam,<BR> =20
pbc_ownr,<BR> =20
pbc_cnam,<BR> =20
pbc_labl,<BR> =20
pbc_lpos,<BR> =20
pbc_hdr,<BR> =20
pbc_hpos,<BR> =20
pbc_jtfy,<BR> =20
pbc_case,<BR> =20
pbc_hght,<BR> =20
pbc_wdth,<BR> =20
pbc_bmap,<BR> pbc_edit=20
)<BR> =20
values<BR> =20
('domicilios',<BR> =20
'sal',<BR> =20
'barrio',<BR> =20
'Barrio:',<BR> 23=20
,<BR> =20
'Barrio',<BR> =20
25,<BR> 23=20
,<BR> 27=20
,<BR> 0=20
,<BR> 0=20
,<BR> =20
'N',<BR> 'Descripci=F3n 40' )=20
;<BR> <BR>insert into =
pbcatcol<BR> =20
(pbc_tnam,<BR> =20
pbc_ownr,<BR> =20
pbc_cnam,<BR> =20
pbc_labl,<BR> =20
pbc_lpos,<BR> =20
pbc_hdr,<BR> =20
pbc_hpos,<BR> =20
pbc_jtfy,<BR> =20
pbc_case,<BR> =20
pbc_hght,<BR> =20
pbc_wdth,<BR> =20
pbc_bmap,<BR> pbc_edit=20
)<BR> =20
values<BR> =20
('domicilios',<BR> =20
'sal',<BR> =20
'ciudad',<BR> =20
'Ciudad:',<BR> 23=20
,<BR> =20
'Ciudad',<BR> =20
25,<BR> 23=20
,<BR> 26=20
,<BR> 0=20
,<BR> 0=20
,<BR> =20
'N',<BR> 'em_integer' )=20
;<BR> <BR>insert into =
pbcatcol<BR> =20
(pbc_tnam,<BR> =20
pbc_ownr,<BR> =20
pbc_cnam,<BR> =20
pbc_labl,<BR> =20
pbc_lpos,<BR> =20
pbc_hdr,<BR> =20
pbc_hpos,<BR> =20
pbc_jtfy,<BR> =20
pbc_case,<BR> =20
pbc_hght,<BR> =20
pbc_wdth,<BR> =20
pbc_bmap,<BR> pbc_edit=20
)<BR> =20
values<BR> =20
('domicilios',<BR> =20
'sal',<BR> =20
'pais',<BR> =20
'Pa=EDs:',<BR> 23=20
,<BR> =20
'Pa=EDs',<BR> =20
25,<BR> 23=20
,<BR> 26=20
,<BR> 0=20
,<BR> 0=20
,<BR> =20
'N',<BR> 'em_smallint' )=20
;<BR> <BR>insert into =
pbcatcol<BR> =20
(pbc_tnam,<BR> =20
pbc_ownr,<BR> =20
pbc_cnam,<BR> =20
pbc_labl,<BR> =20
pbc_lpos,<BR> =20
pbc_hdr,<BR> =20
pbc_hpos,<BR> =20
pbc_jtfy,<BR> =20
pbc_case,<BR> =20
pbc_hght,<BR> =20
pbc_wdth,<BR> =20
pbc_bmap)<BR> =20
values<BR> =20
('domicilios',<BR> =20
'sal',<BR> =20
'croquis',<BR> =20
'Croquis:',<BR> 23=20
,<BR> =20
'Croquis',<BR> =20
25,<BR> 23=20
,<BR> 26=20
,<BR> 0=20
,<BR> 0=20
,<BR> 'N') ;<BR> <BR>insert =
into=20
pbcatcol<BR> =20
(pbc_tnam,<BR> =20
pbc_ownr,<BR> =20
pbc_cnam,<BR> =20
pbc_labl,<BR> =20
pbc_lpos,<BR> =20
pbc_hdr,<BR> =20
pbc_hpos,<BR> =20
pbc_jtfy,<BR> =20
pbc_case,<BR> =20
pbc_hght,<BR> =20
pbc_wdth,<BR> =20
pbc_bmap,<BR> =20
pbc_init,<BR> pbc_edit=20
)<BR> =20
values<BR> =20
('domicilios',<BR> =20
'sal',<BR> =20
'tipo_domicilio',<BR> 'Tipo=20
Domicilio:',<BR> 23=20
,<BR> 'Tipo=20
Domicilio',<BR> =20
25,<BR> 23=20
,<BR> 27=20
,<BR> 0=20
,<BR> 0=20
,<BR> =20
'N',<BR> 'O'=20
,<BR> 'es_tipo_domicilio' )=20
;<BR> <BR>insert into =
pbcatcol<BR> =20
(pbc_tnam,<BR> =20
pbc_ownr,<BR> =20
pbc_cnam,<BR> =20
pbc_labl,<BR> =20
pbc_lpos,<BR> =20
pbc_hdr,<BR> =20
pbc_hpos,<BR> =20
pbc_jtfy,<BR> =20
pbc_case,<BR> =20
pbc_hght,<BR> =20
pbc_wdth,<BR> =20
pbc_bmap,<BR> pbc_edit=20
)<BR> =20
values<BR> =20
('domicilios',<BR> =20
'sal',<BR> =20
'fecha_referencia',<BR> 'Fecha =
Referencia:',<BR> 23=20
,<BR> 'Fecha=20
Referencia',<BR> =20
25,<BR> 23=20
,<BR> 26=20
,<BR> 0=20
,<BR> 0=20
,<BR> =20
'N',<BR> 'em_fechas' )=20
;<BR></FONT></DIV>
<DIV><FONT face=3DCourier=20
size=3D2>____________________________________________________<BR>Sandrigo=
Lezcano=20
Jara &nb=
sp;=20
Asunci=F3n, Paraguay<BR>usando______: Ret Hat 7.2 (Enigma) - Kernel =
2.4.7-10=20
<BR> &nb=
sp; =20
PostgreSQL 7.1.3 - psqlODBC 7.02.00.01<BR>migrando____: Sybase =
6.5 =20
al PostgreSQL <BR>front end___: PowerBuilder=20
6.5 =20
<BR>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DICQ:143590717=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR>_________=
___________________________________________</FONT></DIV></BODY></HTML>
------=_NextPart_000_001B_01C32133.80A8CA20--