Re: Using BLOBs with several DBMS

From: Manika dey <bithi(at)ipr(dot)res(dot)in>
To: Manika dey <bithi(at)ipr(dot)res(dot)in>
Cc: Ricardo Maia <rmaia(at)criticalsoftware(dot)com>, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Using BLOBs with several DBMS
Date: 2001-05-30 15:52:35
Message-ID: Pine.GSO.4.10.10105301051460.17382-100000@sun9.plasma.ernet.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Hi,
Declare the field type as oid for which you
want it to be type blob.
we can surely create and update table with type
blob using jdbc.

manika
>
>
>
>
> -------------------------------------------------------------------
>
> From:- |
> Ms. Manika Dey. |Ph.No:--
> Engineer-SC (Comp. Tech.) | IPR -- 02712 - 69276
> I.P.R | EXT 336,315
> BHAT, GANDHINAGAR | Residence -- 079 - 6745701
> Gujrat -- 382 428 | FAX --- 69017
> ------------------------------------------------------------------
>
>
>
>
>
>
>
>
> On Tue, 29 May 2001, Ricardo Maia wrote:
>
> >
> > Hi,
> >
> >
> > I'm trying to make a application in JAVA that connects thought JDBC to DBMS.
> > It should create tables, insert data and make queries.
> >
> > My question is: how can i create a table with one BLOB field, in a DBMS
> > independent way?
> >
> > I am using PostgreSQL7.1 and Oracle 8 but I want to make it be able to work
> > with other DBMSs.
> >
> >
> > Thanks
> >
> > Ricardo Maia
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
>
>

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Bruce Momjian 2001-05-30 16:34:53 Re: [JDBC] Re: Trouble with JDBC2 ResultSet.getDate()
Previous Message Manika dey 2001-05-30 15:00:59 Re: Using BLOBs with several DBMS