Loading

PostgreSQL + IP2Location

Capture IP data from a new PostgreSQL row (via IP2Location) and add it to a different table

If you're storing IPs in a PostgreSQL table, this integration can scan them for geolocation data and record the results on another. Once active, it will respond to every new row you add on PostgreSQL, automatically sending the IP information to IP2Location and storing the results on a different PostgreSQL table.

If you're storing IPs in a PostgreSQL table, this integration can scan them for geolocation data and record the results on another. Once active, it will respond to every new row you add on PostgreSQL, automatically sending the IP information to IP2Location and storing the results on a different PostgreSQL table.

  1. When this happens...
    PostgreSQLPostgreSQL
    New Row

    Triggered when you add a new row.

    TriggerScheduled
  2. automatically do this...
    IP2LocationIP2Location

    Finds geolocation info about an IP address like city, country, timezone.

    ActionSearch
  3. then do this!
    PostgreSQLPostgreSQL
    New Row

    Triggered when you add a new row.

    ActionWrite
Start free with email
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
    • Table/ViewRequired

    • Order By

    • Dedupe Key

    Trigger
    Scheduled
    Try It
  • PostgreSQL triggers, actions, and search

    New Table

    Triggered when you add a new table.

    Trigger
    Scheduled
    Try It
    • TableRequired

    Action
    Write
    • TableRequired

    • Lookup ColumnRequired

    • Lookup ValueRequired

    Action
    Search
postgresql logo
postgresql logo

About PostgreSQL

PostgreSQL is a powerful, open-source database engine with a uniquely advanced query optimizer and dozens of built in features, making it an easy choice for production databases.
Learn moreHelp

Related categories

  • Databases

Similar apps

MySQL integrationsMySQL integrations

MySQL

Databases
SQL Server integrationsSQL Server integrations

SQL Server

Databases
Amazon Relational Database Services (RDS) integrationsAmazon Relational Database Services (RDS) integrations

Amazon Relational Database Services (RDS)

Amazon, Databases
ip2location logo
ip2location logo

About IP2Location

IP2Location is a non-intrusive geo IP solution to help you to identify a visitor's geographical location.

Related categories