Re: Using Image datatype in Postgres

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