Beginner's question about ODBC and/or foreign data sources

From: groberge(at)andforthelamb(dot)org
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Beginner's question about ODBC and/or foreign data sources
Date: 2012-10-15 17:52:16
Message-ID: 586b0ff7dbfba893abdaa5872e66e801@andforthelamb.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Greetings.

I have installed and used PostgreSQL at a beginner's level (simple
database creation, simple PHP website querying) and would love to use it
at work to complement and/or (hopefully) replace Access as our software
of choice.

Anyhow, I'm trying to find information on how to connect PostgreSQL to
an ODBC data source. I've seen a lot of information on connecting TO
PostgreSQL from other (ODBC) sources, but I can't locate a clear
description of how to access data FROM ODBC sources to query within
PostgreSQL. I have software which offers Windows ODBC drivers, but need
to get at it from PostgreSQL.

I may be entirely misunderstanding the ODBC issue, but it seems that
the PostgreSQL ODBC drivers are for connecting TO PostgreSQL, and not
what I am trying to accomplish.

Do I need to be messing with/foreign data wrappers here?

Thank you for your patience with this silly question!
George R.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2012-10-15 18:42:57 Re: Beginner's question about ODBC and/or foreign data sources
Previous Message Tom Lane 2012-10-15 13:52:37 Re: Equivalence of CROSS JOIN and comma