| From: | "Afewtips(dot)com" <afewtips(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Connect to SQL Server via ODBC from Postgresql |
| Date: | 2008-01-04 15:08:49 |
| Message-ID: | 85641af1-bd5d-41cf-b6b1-ec40efddf33a@e23g2000prf.googlegroups.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
I am new to this product and don't quite know what can and cannot be
done.
I need to submit queries to a SQL Server database and create a table
in Postgresql with the results from SQL Server.
Normally I would do this with an ODBC driver into SQL Server, but I
don't see any references to doing that with Postgresql, only connect
to the Postgresql table from another database with ODBC.
I do read mentions about dblink connections, but how to install it
looks unclear and complicated.
(I didn't install the PostgreSQL source and it seems that it is needed
to install dblink. Does dblink have a standard application install?)
I am running 8.2 - any help would be very appreciated!
Thanks
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Glaesemann | 2008-01-04 15:13:16 | Re: How to handle 'not a number' in postgresql |
| Previous Message | Ivan Sergio Borgonovo | 2008-01-04 15:02:54 | Re: Best free open source ER diagram generator? |