On Wed, Aug 4, 2010 at 3:41 PM, Peter Koczan <pjkoc...@gmail.com> wrote:
> Yep, that's the stumbling block we're running into. ODBC and these > fields' assumptions of true/false are at odds. I'm trying a few other > things with casts in the meantime to see if they'll work. Well there is a solution that I've been toying around with. In PostgreSQL, there are many data-types that cannot be expressed directly in an MS-Access Linked table. For example, composite types, arrays, range types, hstores, postgis types et.al. However, most of these types can be decomposed in to base types that can be express in linked tables. The key is using update-able views to decompose the data for Access and re-assemble it before it transmitted back to the base table. The same can be done for boolean datatype. > Does anyone know if another product, like OpenOffice Base with its > native postgres driver, does any better? >From my limited experience, I believe is does do better. The following blogs as a few entries about using Base: http://www.postgresonline.com/journal/archives/167-Importing-data-into-PostgreSQL-using-Open-Office-Base-3.2.html -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
