PostgreSQL Connection

About PostgreSQL

PostgreSQL is a powerful, open-source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, and has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports the storage of large binary objects, including pictures, sounds, or videos.

Connection

Comments

User fields

Creating New Connection

• In the Name Text Box type in a new name for the connection you are about to create
• Type in the hostname
• Select a Database name from the drop-down List
• Select appropriate connection port default is 5432
• Fill in the Username/Password for the database you wish to connect to
• Fill in SSL/SSH connection details if necessary
• Click Test Connection to ensure the details you have provided are correct
• Click OK to close the connection properties window

Used by

1. PostgreSQL Reader
2. PostgreSQL Writer
3. Database Loop Action
4. Sql Script Action
5. Sql Data Check Action
6. Check Connection Action
7. SQL To Text Dynamic Action
8. SQL To XML Dynamic Action
9. SQL To Insert Dynamic Action
10. SQL To Excel Dynamic Action
11. SQL To QVD Dynamic Action
12. SQL To QVX Dynamic Action
13. Select Value Action
14. SQL Record to Variables Action
15. SQL to Variables Action