Re: Postgres and Access - Mailing list pgsql-admin

From Robert Treat
Subject Re: Postgres and Access
Date
Msg-id 1054910777.29944.331.camel@camel
Whole thread Raw
In response to Postgres and Access  ("Nathalie Boulos" <nathalieboulos@hotmail.com>)
List pgsql-admin
On Tue, 2003-05-27 at 09:26, Nathalie Boulos wrote:
> Hello everyone,
>
> I was able to open postgresql tables on linux from MS-access on windows
> using the ODBC found on postgresql.org website.
>
> I was wondering if there is a way that a postgres database on linux sees and
> modifies access or fox-pro database files.
>

no, postgresql is a database back-end and can only work directly on it's
own back-end files. Contrast to access which is both a database
front-end and back-end; the access front-end can talk to other database
back-end's via odbc.   With that said, you can convert back-end database
files from access to postgresql, one such program that does this is
pgadmin (pgadmin.postgresql.org).

hth,

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


pgsql-admin by date:

Previous
From: Alex.H.Pollock@WellsFargo.COM
Date:
Subject: Diagnose Database Corruption
Next
From: Andrew Sullivan
Date:
Subject: Re: Starting postmaster as a service (newbie)