Re: Using Image datatype in Postgres

Also, you can use bytea types to hold binary data, but you have to encode
it first.  Advantage is that you don't have to use lo support to get your
data in and out.

On Tue, 17 Dec 2002, Medi Montaseri wrote:

> create SomeTable
> (
>     name varchar(10),
>     image oid
> );
> insert into SomeTable (name, image) values ('foo.gif',
> lo_import('/web/some.gif'));
>
> ie
>
> Bag of Bits is called Large Objects in PG and you'll use a couple of
> auxilary methods
> to handle them; lo_import() and lo_export().
>
> I myself don't understand the relation between OID and Large Object....
> Could be historic stuff....or when I read it, i was sleepy....
>
> Prachi Jain wrote:
>
> > Hello All,
> >
> > I am migrating from MSSQLServer to Postgres. I was using image
> > datatype in one of my table. Is there any replacement for the same in
> > Postgres???
> >
> > Please guide.
> > thanks and regards
> > Prachi Jain
> >
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>