Skip to main content

PostgreSQL

Connect to and interact with PostgreSQL databases for data operations and automation.

Overview​

The PostgreSQL package provides database connectivity for PostgreSQL. Use it when you need to query data, insert records, execute statements, or perform transactions against PostgreSQL databases.

Key Features​

  • Query Execution - Run SELECT queries and get results
  • Data Modification - INSERT, UPDATE, DELETE operations
  • Transactions - Manage database transactions

Available Nodes​

  • Connect - Establish connection to PostgreSQL database
  • Disconnect - Close database connection
  • Query - Execute SELECT query and return results
  • Non Query - Execute INSERT, UPDATE, DELETE statements
  • Insert - Insert data into a table
  • Start - Begin a database transaction
  • Commit - Commit the current transaction

When to Use This Package​

  • Data Extraction: Query and export data from PostgreSQL
  • Data Entry: Insert automation results into database
  • Report Generation: Pull data for automated reports
  • System Integration: Connect RPA with PostgreSQL backend
  • Data Validation: Check database state during workflows

Connection​

Standard PostgreSQL connection with host, port, database, user, password.

Typical Workflow​

  1. Connect with database credentials
  2. Query to retrieve data
  3. Process data in your automation
  4. Insert or Non Query to write results
  5. Disconnect when finished

Transaction Support​

For atomic operations:

  1. Start transaction
  2. Perform multiple insert/update operations
  3. Commit if all succeed

Use Cases​

  • Extract customer data for reporting
  • Insert processed records from automation
  • Synchronize data between systems
  • Validate data before processing
  • Update status flags in database