| Lists: | pgsql-hackers |
|---|
| From: | "Edward Di Geronimo Jr(dot)" <edigeronimo(at)xtracards(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | ODBC link to other databases |
| Date: | 2005-11-02 21:49:29 |
| Message-ID: | 43693469.7040508@xtracards.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Hello all,
To help with my work, I've created a basic plugin that allows Postgres
to retreive data from tables on other databases via ODBC. So far I've
only tested it against MS SQL Server 2000. It's rather crude at the
moment, as the only operation supported is a SELECT * query, and it
currently requires the username/password to be hard coded into the
source code.
I was wondering if other people are interested in this enough for me to
bother with the trouble of polishing this off.
I also have no idea what would be a sane security model for this.
I'd appreciate people letting me know if there is interest in this...
Ed
| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | "Edward Di Geronimo Jr(dot)" <edigeronimo(at)xtracards(dot)com> |
| Subject: | Re: ODBC link to other databases |
| Date: | 2005-11-02 22:09:56 |
| Message-ID: | 200511021409.56926.josh@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Edward,
> To help with my work, I've created a basic plugin that allows Postgres
> to retreive data from tables on other databases via ODBC. So far I've
> only tested it against MS SQL Server 2000. It's rather crude at the
> moment, as the only operation supported is a SELECT * query, and it
> currently requires the username/password to be hard coded into the
> source code.
http://pgfoundry.org/projects/dbi-link/
http://pgfoundry.org/projects/dblink-tds/
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco