I use pgadmin II to access postgresql and they have a sweet little plugin
called the Database Migration Wizard which lets you export access tables as
well as a variety of others. It uses the odbc driver so I don't know if it
will work around your problem but it might be a try. Either way, I find
pgAdmin II makes my life a lot simpler when it comes to working with
postgresql.
Julie
----- Original Message -----
From: "Cheryl Thompson" <cthompso@ci.irving.tx.us>
> Is there a way to copy/export the DB (or it's tables) to another DB and
dump
> all this stuff that's causing the problems? In particular, in the past I
> have exported the entirety of a database into a flat file and imported it
> into a "clean" version.