Re: Deferrable on foreign keys in exported schema

Nirgal Vourgère <contact_mdbtools <at> nirgal.com> writes:

> In example http://www.nirgal.com/mdbtools/debian.squeeze/mdb2pgsql script,
> foreign keys and indexes are output on standard output 3, so they can be
> processed at the end. Importing the indexes at the end really speed up the
> process.
> 
> You might find there usefull ideas there, such as support for tables with
> quotes and slashes in names, support for dates before 1000AD, sequences
> initialisations... On the other end, you probably don't want to add OIDS...

Thanks Nirgal,

That looks like it took some effort!  My shell scripting isn't up to that level,
so I'd never have come up with that sort of thing on my own.  We only want to
have a read-only Postgres copy of the Access database, we'll never be inserting
data after import, so deferrable is not necessary, and your solution will work
fine.

Thanks again,

Peter


------------------------------------------------------------------------------
Colocation vs. Managed Hosting
A question and answer guide to determining the best fit
for your organization - today and in the future.
http://p.sf.net/sfu/internap-sfd2d
_______________________________________________
mdbtools-dev mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mdbtools-dev