field of type oid

From: "RaviShankar K" <ravi(at)e-jan(dot)co(dot)jp>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: field of type oid
Date: 2001-08-06 18:00:57
Message-ID: 01d901c11ea1$bf1c10a0$0400a8c0@ejan.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi ,

I have 2 tables in my postgres DB .
2 tables have a field "my_image" of type "oid" ( Blob) .

I have to
1.get a row from table A
2.insert it in table B
3.delete that from table A .

Can I do like this ?
ResultSet rs ;
PreparedStatement pstmt;
String qry2 = "SELECT * FROM A";
String qry = "INSERT INTO B (my_image) VALUES(?)";

/*This part is doubtful to me */
pstmt.setInt(rs.getInt("my_image"));

I am using rs.getInt() because I need only oid . It is working fine
when I tested this code.
I am able to insert integer in to field of type oid . I can retrieve
image(Blob object) from table B using that inserted integer.

However I don't know how much correct this way is . Please advice me.
Thanks in advance.

Regards,
Ravi

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2001-08-07 02:04:24 Re: field of type oid
Previous Message Barry Lind 2001-08-06 16:31:16 Re: Retrieving field of type bigint[]