MapInfo Pro

Welcome to the MapInfo Pro community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Product Documentation  Ideas Portal

Discussions

Members

Resources

Events

 View Only
Back to discussions
Expand all | Collapse all

Accessing PostGres SQL data from MapInfo tables as direct Live access, keeping the PostGres Index data field in MapInfo.

  • 1.  Accessing PostGres SQL data from MapInfo tables as direct Live access, keeping the PostGres Index data field in MapInfo.

    Posted 03-15-2018 09:15

    I have LLPG Gazetteer data stored in PostGres SQL ,indexed on attribute field UPRN.

    I can access the data via MapInfo Pro using Direct Live Link (preferred option) but the UPRN Index field is not retained in the MapInfo table so data retrieval is very slow.How do I ensure that MapInfo Table recognises the UPRN Indexed field?



  • 2.  RE: Accessing PostGres SQL data from MapInfo tables as direct Live access, keeping the PostGres Index data field in MapInfo.

    Employee
    Posted 03-15-2018 07:37

    I would recommend that you access the data using a Linked table. In that way the entire dataset will get downloaded and you can index the UPRN column for quick searching.

    Alternatively, you could use a small MapBasic application that connects to your PostgreSQL database and lets you search for records in the Gazateer data table. In this way the index on the URPN column can be used as the tool can pass the query to the database.

    Let me dig thru my tools as I might actually have such a tool - it might however not be quite productized.