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
under250k 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@NLE [mailto:bob@nleaudio.com]
> > Sent: Wednesday, July 10, 2002 6:37 PM
> > To: pgsql-general@postgresql.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