From: | Yves Dorfsman <x(at)x(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: importing into postgres from access |
Date: | 2000-07-11 03:15:53 |
Message-ID: | Jjwa5.67381$ef6.867004@news1.rdc1.ab.home.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
nsrona <svngo(at)earthlink(dot)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(at)cuug(dot)ab(dot)ca
http://www.cuug.ab.ca/~dorfsmay
From | Date | Subject | |
---|---|---|---|
Next Message | Byron Nikolaidis | 2000-07-11 03:33:23 | Re: [INTERFACES] Re: Link to postgesql components |
Previous Message | Tom Lane | 2000-07-11 02:46:18 | Re: Auto-increment and data importing: problem pointed out in PHP builder review? |