From: Byron Nikolaidis <byronn@insightdist.com>
To: Giuseppe Tanzilli <g.tanzilli@fr.flashnet.it>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Memo field in MS Access
Date: Thu, 09 Jul 1998 11:21:40 -0400
Message-ID: <35A4E004.141DD279@insightdist.com> (raw)
References: <35A475E6.D326BAC6@fr.flashnet.it>
Giuseppe Tanzilli wrote:
> Hi,
> I was porting an Access database to PostgreSQL and I found a
> problem.
> I had ~12K memo text field in Access, I can't port this to pgsql.
> I do not need index, compare on this field.
>
> There is a way to map a field as a large object ?
>
Currently, the odbc driver only allows for SQL_LONGVARBINARY to be
mapped to a large object, and that is because we have a special "lo"
data type that we create in Postgres. (See our FAQ on our website for
how to do this)
For your case, we would also need to create an "lo_text" data type that
would then be mapped to SQL_LONGVARCHAR by the driver. Also, we would
need an option to go the other way because currently, SQL_LONGVARCHAR is
mapped to a postgres 'text' type. Most users are happy with this
mapping so we would need an option.
I could add it to my TODO list but if you need it only for one time to
import the data, I could just send you a modified version that maps it
the way you want.
Byron
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: byronn@insightdist.com, g.tanzilli@fr.flashnet.it
Subject: Re: [INTERFACES] Memo field in MS Access
In-Reply-To: <35A4E004.141DD279@insightdist.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox