DBDesigner et PostgreSQL

How to configure DBDesigner to connect with PostgreSQL (Win XP)

First what you have to do is download odbc driver to PostgreSQL. You can find it on this site:
ODBC driver . Instalation is very simple, just click next, next ... After that you can configure your postgresql odbc connection go to:

* menu
* control panel
* admin tools
* sources data (ODBC)

Open the last one, select user dsn tab, click add. Scroll down and find PostgreSQL driver name, select PostgreSQL Unicode, then click OK. After that you will see window perform field like below :

* data source: PostgreSQL30W
* database: your database name which you want connect
* server: localhost (if it's on this same machine)
* user name: user name ;)
* description: can be empty
* SSL mode: disable (or choice what you need)
* port: 5432
* password: ****** (user pass)

Then you can try test this setting by click test, if you will see "Connection succsessful" everything is ok now you can run dbdesigner;
Go:
-> file;
-> open from databse;
-> choice ODBC -> NewODBCConn
-> click New Database connection.

You will see window perform field like below:

* connection name: whatever
* driver: should be selected odbc if not select it
* connection settings: don't touch
* odbc dsn name: PostgreSQL30W
* username: user name ;)
* password: ***** (user pass)
*
*

Close this window and go to Database -> Reverse Engineering. You will see window called Select Database Connection, so select your connection and click Connect. On the next window you can select what you want import from db (choice it on Schema) after that just click "Execute". And that's all. After that you will see that what you selected on schema.