Image field in SQL Server 2005 to lo field in PostGres 8.2

[robykeys82]

Hi! I'm an Italian user of PostGres and I'm having some trouble! I hope you can help me!
I'm trying to migrate the db content from SQL SERVER 2005 to PostGreSQL. Everything works ok except for the "image" fields. I have this code:


PGComm.CommandT ext = "INSERT INTO "table name"(p1 p2 p3 p4 p5....)"
+ "VALUES(:p1 , :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9, :p10, :p11, :p12, :p13);";

............... ............... ....
PGComm.Paramete rs.Add("p7", NpgsqlTypes.Npg sqlDbType.Integ er);
PGComm.Paramete rs.Add("p8", NpgsqlTypes.Npg sqlDbType.Varch ar, 1);
PGComm.Paramete rs.Add("p9", NpgsqlTypes.Npg sqlDbType.Varch ar, 1);
PGComm.Paramete rs.Add("p10",Np gsqlTypes.Npgsq lDbType.Timesta mp);
PGComm.Paramete rs.Add("p11",Np gsqlTypes.Npgsq lDbType.Varchar , 50);
PGComm.Paramete rs.Add("p12",Np gsqlTypes.Npgsq lDbType. ????? );

foreach (DataRow dr in dataTable.Rows)
{
............... ..............
PGComm.Paramete rs[7].Value = dr[7];
PGComm.Paramete rs[8].Value = dr[8];
PGComm.Paramete rs[9].Value = dr[9];
PGComm.Paramete rs[10].Value = dr[10];
PGComm.Paramete rs[11].Value = dr[11];
PGComm.Paramete rs[12].Value = dr[12];

PGComm.ExecuteN onQuery();
}

Now, the problem is: as long as I have to deal with Integer and VarChar, everything works fine. But for a field which in the SQL table is of type "image", which type I have to pass as a parameter? lo is not present in NpgsqlDbType, and if I use Bytea everything freezes when I launch the command.

Where am I wrong? I hope someone could help! Thanks in advance,
Roberto