[postgis-users] Is there a MapInfo to PostGIS/PostgreSQL loader?

[Bo Victor Thomsen]

Shao -

If you want to visualize spatial data in a Postgres/PostGIS database 
using MapInfo as the viewing program you have to:

  * Create a schema / table in : *MAPINFO.MAPINFO_MAPCATALOG. *
  * Populate it with information about your spatial tables in the
    Postgres database. It contains approximately the same information
    that's stored in the normal *public.geometry_columns* view plus some
    extra MapInfo specific information.

MapInfo uses this table to get information about the different spatial 
tables in the database, so it has to be present and populated with the 
correct information.

If you use OGR2OGR to upload spatial data to Postgres, OGR2OGR 
*won't***create or populate the *MAPINFO.MAPINFO_MAPCATALOG* meta-table 
for you. However,  the Easyloader upload program is capable of that. 
Finally, you can create and populate the *MAPINFO.MAPINFO_MAPCATALOG* 
table manually.

You can download the Easyloader program from the Pitney Bowes MapInfo 
Web site (Free download)

I suggest you read (and understand) the following article from the 
MapInfo knowledge base: 
http://support.pitneybowes.com/VFP05_KnowledgeWithSidebarHowTo?id=kA180000000PNiiCAG

-- 
Med venlig hilsen / Kind regards

Bo Victor Thomsen
aestasGIS Denmark


Den 31-08-2019 kl. 17:41 skrev Shaozhong SHI:
> Hi, Jeff,
> Thanks.  We can upload and visualise in qgis.
> But, I wonder where upload can include metadata.
> If you use qgis, you can use the data, but when you click on 
> properties, you cannot find metadata.
> How to upload metadata into postgis/postgresql?
> Regards,
> Shao
>
> On Friday, 30 August 2019, Jeff Norville <jeff at jnorville.com 
> <mailto:jeff at jnorville.com>> wrote:
>
>     Hi Shao,
>
>     I generally use QGIS to visualize postgis / postgresql loads - but
>     mostly because it's free. But if you're using MapInfo it seems the
>     EasyLoader may be the way forward - there are some posts about
>     this over on gis.stackexchange.com <http://gis.stackexchange.com>,
>     including this guide:
>     https://www.slideshare.net/peterhorsbollmoller/mapinfo-professional-120-and-sql-server-2008
>     <https://www.slideshare.net/peterhorsbollmoller/mapinfo-professional-120-and-sql-server-2008>
>
>     Best,
>     Jeff
>
>     On Tue, Aug 27, 2019 at 9:03 PM Shaozhong SHI
>     <shishaozhong at gmail.com <mailto:shishaozhong at gmail.com>> wrote:
>
>         Hi, Tonis,
>         We will bear that in mind.
>         A friend of mine says that the problem is not being able to
>         visualize what got into postgre.
>         Regards,
>         Shao
>
>         On Tuesday, 27 August 2019, Tõnis Kärdi <tonis.kardi at gmail.com
>         <mailto:tonis.kardi at gmail.com>> wrote:
>
>             Hi,
>
>             one option would be to use ogr2ogr. And I can't remember
>             exactly but I think MapInfo's EasyLoader could do that
>             very fine aswell.
>
>             All the best,
>             Tõnis
>
>             On 27.08.19 15:44, Paolo Cavallini wrote:
>
>                 Not that I know of, but you can use ogr or QGIS for this.
>                 Cheers.
>
>                 On 27 August 2019 15:14:06 EEST, Shaozhong SHI
>                 <shishaozhong at gmail.com
>                 <mailto:shishaozhong at gmail.com>> wrote:
>
>                     Hi,
>                     Is there a MapInfo to PostGIS/PostgreSQL loader? 
>                 For instance, use
>                     psql.exe or something like that?
>
>                     Regards,
>
>                     Shao
>
>
>                 -- 
>                 Sorry for being short
>
>                 _______________________________________________
>                 postgis-users mailing list
>                 postgis-users at lists.osgeo.org
>                 <mailto:postgis-users at lists.osgeo.org>
>                 https://lists.osgeo.org/mailman/listinfo/postgis-users
>                 <https://lists.osgeo.org/mailman/listinfo/postgis-users>
>
>             _______________________________________________
>             postgis-users mailing list
>             postgis-users at lists.osgeo.org
>             <mailto:postgis-users at lists.osgeo.org>
>             https://lists.osgeo.org/mailman/listinfo/postgis-users
>             <https://lists.osgeo.org/mailman/listinfo/postgis-users>
>
>         _______________________________________________
>         postgis-users mailing list
>         postgis-users at lists.osgeo.org
>         <mailto:postgis-users at lists.osgeo.org>
>         https://lists.osgeo.org/mailman/listinfo/postgis-users
>         <https://lists.osgeo.org/mailman/listinfo/postgis-users>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190831/86d1c197/attachment.html>