Re: importing into postgres from access

nsrona <svngo@earthlink.net> wrote:
> I currently have postgres on a Linux 6.2 machine & I can access all of its
> information from any windows machine using the proper odbc driver.

> Now I want to go in the other direction - Is there a way for my postgres
> server on the linux box to pull down information from a windows client that
> is using an Access Database?

I'm relatively new to postgres *and* I'm not sure if I understand your
question right:

You want "postgres" to connect to another DB server, and populate a
postgres table from a table in that other DB server ???

If that's the case, I'm pretty sure it's not possible. PostgreSQL is a DB
server, not a client, and actually I believe this is true for most (all
?) DB server: They can act as server and server only, not as client.

Now, one thing you might want to look into, and again assumning I
understood the question right, is to look at perl and DBI. What this would
allow you to do is run a perl script on the Linux box that connects to
both servers (postgres on Linux, and whichever on Windows), and populate
one table from one with data from a table on the other server. IF you know
a litle perl, this is trivial to do.




Yves.
----
Yves Dorfsman                                        dorfsmay@cuug.ab.ca
                                         http://www.cuug.ab.ca/~dorfsmay