Importing PostgreSQL Database Tables
1. Click the Import button in the CONNX Data Dictionary Manager window.
2. Select CONNXStore from the Import Type list box.
This is the name CONNX uses for imports of PostgreSQL data.
3. Type the PostgreSQL database name in the Enter the database name text box.
4. Specify the full path for the database.
Select the Include System Tables check box if you want to import table definitions into the CDD.
Select the Get Statistics check box to identify the table sizes.
5. Type a server location, user name, and password under Logon Information.
a. Server - Name of the system running CONNX PostgreSQL.
b. UserName - User name used to log in to the account where the database resides.
c. Password - Password used to log in to the account where the database resides.
d. TCP/IP Port - Port 5432 is listed in the TCP/IP Port text box by default. If you have a firewall in place or need use of a specific port, enter the port number.
6. Click the OK button.
The CONNX Import Table Selection dialog box appears with a list of available table names.
7. Click the Add or Add All button to move the tables to the Select Tables for Import pane.
8. Click the OK button to import the selected tables into CONNX.
The PostgreSQL database tables are added to the list of accessible objects in the CONNX Data Dictionary Manager window.