Re: Converting from .MDB Access to PostgreSQL

HI Bob (& all),

I do not know how large the data could be. It could be a picture, it could be anything... I would say it should be under 250k long. What type should I use for this? Is
there not a generic "byte" type variable that can handle say a meg of undefined data?

Bob

> Bob,
>
> What data is being stored in these fields? You might be able to get
> away with using a BLOB field, but you'll need to know what is being stored
> and how it's being used to make sure you'll get the same functionality out
> of storing it this way.
>
> Rob
>
> > -----Original Message-----
> > From: Bob Puff(at)NLE [mailto:bob(at)nleaudio(dot)com]
> > Sent: Wednesday, July 10, 2002 6:37 PM
> > To: pgsql-general(at)postgresql(dot)org
> > Subject: Re: [GENERAL] Converting from .MDB Access to PostgreSQL
> >
> >
> > Thanks for everyone's comments. I tried using Access to
> > export to the odbc database, but no go. I then tried
> > PgAdmin, which has sucessfully converted a few databases, but
> > I am still stuck on some others.
> >
> > The ones that won't convert have tables with entries of type
> > "OLE Object", of which I don't see a corresponding field type
> > in Postgres. How do I get past this?
> >
> > Bob