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
Start free with email
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
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.
Help

Related categories

  • Developer Tools