PostgreSQL ODBC Drivers on Windows 7 not showing up

odbcpostgresql

I'm running win7 64bit so I installed the (psqlodbc_09_00_0300-x64.zip) msi 64bit drivers for postgres odbc.

i also tried launching the odbc manager from the following location "%systemdrive%\Windows\SysWoW64\odbcad32.exe"

But i still don't see any postgres drivers i can use.

Anyone know how to make them show up?

enter image description here

Best Answer

To setup DSN for 32-bit application you must use: %WINDIR%\SysWOW64\odbcad32.exe and for 64-bit application you must use: %WINDIR%\System32\odbcad32.exe

see http://psqlodbc.projects.pgfoundry.org/faq.html#6.8

Related Solutions

PostgreSQL “DESCRIBE TABLE”

Try this (in the psql command-line tool):

\d+ tablename

See the manual for more info.

PostgreSQL: Show tables in PostgreSQL

From the psql command line interface,

First, choose your database

\c database_name

Then, this shows all tables in the current schema:

\dt

Programmatically (or from the psql interface too, of course):

SELECT * FROM pg_catalog.pg_tables;

The system tables live in the pg_catalog database.

Best Answer

Related Solutions

PostgreSQL “DESCRIBE TABLE”

PostgreSQL: Show tables in PostgreSQL

Related Topic