Re: Postgresql and ODBC > MsAccess

[Martin L. <m-l...@le...>]

"Oscar Buijten" <os...@el...> writes:

> I currently have information stored in a Access97 database.
> 
> Part of this information I would need to transfer to Postgresql (on a
> linux box (Mandrake 8.0) to use it in the SQL-ledger.
> 
> Question is: how to do this?

The "easiest" way is to export your tables from access with a
delimiter (i.e. ";") and reimport this data to postgres using the "copy from"
command. Look at the SQL-Reference which is part of the Reference Manual.

> I assume I would need to do it using ODBC, but I have no clue what to
> install (as a driver) and where to install it (on the linux box or on
> the wondoze box).

There exists a ODBC-Driver you can use for accessing PG-Databases via
i.e. access. But IMHO the way described above is the faster way, if you
don't want to access the PG-Database permanently via M$-access.

In any cases you have to rebuild constraints and relations between
tables by hand, it is not possible to export/import them.

HTH, Martin

BTW: Could you please post plain-text instead of HTML next time? Thx