<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Shao -</p>
<p>You are correct to assume, that schemas is a fundamental concept
in relational database technology. But it's not a concept limited
to PostGIS but is used throughout all database parts. Allmost all
literature about PostGIS assumes you have some basic knowledge of
PostgreSQl (relational SQL databases).<br>
</p>
<p>You can simply visualize the entire database as a set of <i>containers</i>
called <i>schemas</i>. Each schema (container) contains a set of
object like tables, indexes, views, functions and others. The
benefit of dividing the database into schemas is - among other
benefits - that you can divide all the database objects in logical
chunks in a orderly fashion. <br>
</p>
<p>As an <i>example</i>: You can define security in a database at
the schema level and not the table level. Instead of administer
all the individual tables you work with security on the schema
level and afterward place each of the tables in the relevant
schema. This radically minimize the workload associated with
security administration. </p>
<p>If you compare a database to a file-system: The tables would be
the files. The schemas would be the directories where the files
reside in.</p>
<p>Take a look at this article
<a class="moz-txt-link-freetext" href="https://www.lifewire.com/definition-of-a-schema-in-a-database-1019262">https://www.lifewire.com/definition-of-a-schema-in-a-database-1019262</a><br>
</p>
Den 31-08-2019 kl. 22:58 skrev Shaozhong SHI:<br>
<blockquote type="cite"
cite="mid:CA+i5JwagUj-vSOj9LhK+B_SeWWXGHBj6B6jJAvJPB-Qdkekn+g@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
Hi,
<div>Interesting.</div>
<div>Surely, the fundamental is how the data is stored in
postgresql and how it is accessed.</div>
<div><br>
</div>
<div>If you come across more detailed articles, please let me
know.</div>
<div><br>
</div>
<div>In postgis, the term schema is prominent, but it is not well
explained or used.</div>
<div>Regards,</div>
<div>Shao <br>
<br>
On Saturday, 31 August 2019, Bo Victor Thomsen <<a
href="mailto:bo.victor.thomsen@gmail.com"
moz-do-not-send="true">bo.victor.thomsen@gmail.com</a>>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<p>Shao -</p>
<p>If you want to visualize spatial data in a
Postgres/PostGIS database using MapInfo as the viewing
program you have to:</p>
<ul>
<li> Create a schema / table in : <b><span><span><span
style="font-family:monospace">MAPINFO.MAPINFO_MAPCATALOG.
</span></span></span></b><br>
</li>
<li>Populate it with information about your spatial tables
in the Postgres database. It contains approximately the
same information that's stored in the normal <b>public.geometry_columns</b>
view plus some extra MapInfo specific information. <br>
</li>
</ul>
<p>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.</p>
<p>If you use OGR2OGR to upload spatial data to Postgres,
OGR2OGR <b>won't</b><b> </b>create or populate the <b><span><span><span
style="font-family:monospace">MAPINFO.MAPINFO_MAPCATALOG</span></span></span></b>
meta-table for you. However, the Easyloader upload
program is capable of that. Finally, you can create and
populate the <b><span><span><span
style="font-family:monospace">MAPINFO.MAPINFO_MAPCATALOG</span></span></span></b>
table manually.</p>
<p>You can download the Easyloader program from the Pitney
Bowes MapInfo Web site (Free download)<br>
</p>
<p>I suggest you read (and understand) the following article
from the MapInfo knowledge base:
<a
href="http://support.pitneybowes.com/VFP05_KnowledgeWithSidebarHowTo?id=kA180000000PNiiCAG"
target="_blank" moz-do-not-send="true">http://support.pitneybowes.<wbr>com/VFP05_<wbr>KnowledgeWithSidebarHowTo?id=<wbr>kA180000000PNiiCAG</a></p>
<pre cols="72">--
Med venlig hilsen / Kind regards
Bo Victor Thomsen
aestasGIS Denmark
</pre>
<p> <br>
</p>
<div>Den 31-08-2019 kl. 17:41 skrev Shaozhong SHI:<br>
</div>
<blockquote type="cite"> Hi, Jeff,
<div>Thanks. We can upload and visualise in qgis.</div>
<div>But, I wonder where upload can include metadata.</div>
<div>If you use qgis, you can use the data, but when you
click on properties, you cannot find metadata.</div>
<div>How to upload metadata into postgis/postgresql?</div>
<div>Regards,</div>
<div>Shao<br>
<br>
On Friday, 30 August 2019, Jeff Norville <<a
href="mailto:jeff@jnorville.com" target="_blank"
moz-do-not-send="true">jeff@jnorville.com</a>>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">
<div>Hi Shao,</div>
<div><br>
</div>
<div>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 <a
href="http://gis.stackexchange.com"
target="_blank" moz-do-not-send="true">gis.stackexchange.com</a>,
including this guide:<br>
</div>
<div><a
href="https://www.slideshare.net/peterhorsbollmoller/mapinfo-professional-120-and-sql-server-2008"
target="_blank" moz-do-not-send="true">https://www.slideshare.net/pet<wbr>erhorsbollmoller/mapinfo-profe<wbr>ssional-120-and-sql-server-<wbr>2008</a></div>
<div><br>
</div>
<div>Best,</div>
<div>Jeff<br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Tue, Aug 27,
2019 at 9:03 PM Shaozhong SHI <<a
href="mailto:shishaozhong@gmail.com"
target="_blank" moz-do-not-send="true">shishaozhong@gmail.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px
0px 0px 0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">Hi, Tonis,
<div>We will bear that in mind. </div>
<div>A friend of mine says that the problem is not
being able to visualize what got into postgre.</div>
<div>Regards,</div>
<div>Shao<br>
<div><br>
On Tuesday, 27 August 2019, Tõnis Kärdi <<a
href="mailto:tonis.kardi@gmail.com"
target="_blank" moz-do-not-send="true">tonis.kardi@gmail.com</a>>
wrote:<br>
<blockquote class="gmail_quote"
style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">Hi,<br>
<br>
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.<br>
<br>
All the best,<br>
Tõnis<br>
<br>
On 27.08.19 15:44, Paolo Cavallini wrote:<br>
<blockquote class="gmail_quote"
style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex"> Not
that I know of, but you can use ogr or
QGIS for this.<br>
Cheers.<br>
<br>
On 27 August 2019 15:14:06 EEST, Shaozhong
SHI <<a
href="mailto:shishaozhong@gmail.com"
target="_blank" moz-do-not-send="true">shishaozhong@gmail.com</a>>
wrote:<br>
<br>
Hi,<br>
Is there a MapInfo to
PostGIS/PostgreSQL loader? For instance,
use<br>
psql.exe or something like that?<br>
<br>
Regards,<br>
<br>
Shao<br>
<br>
<br>
-- <br>
Sorry for being short<br>
<br>
______________________________<wbr>_________________<br>
postgis-users mailing list<br>
<a
href="mailto:postgis-users@lists.osgeo.org"
target="_blank" moz-do-not-send="true">postgis-users@lists.osgeo.org</a><br>
<a
href="https://lists.osgeo.org/mailman/listinfo/postgis-users"
target="_blank" moz-do-not-send="true">https://lists.osgeo.org/mailma<wbr>n/listinfo/postgis-users</a><br>
<br>
</blockquote>
______________________________<wbr>_________________<br>
postgis-users mailing list<br>
<a
href="mailto:postgis-users@lists.osgeo.org"
target="_blank" moz-do-not-send="true">postgis-users@lists.osgeo.org</a><br>
<a
href="https://lists.osgeo.org/mailman/listinfo/postgis-users"
target="_blank" moz-do-not-send="true">https://lists.osgeo.org/mailma<wbr>n/listinfo/postgis-users</a></blockquote>
</div>
</div>
______________________________<wbr>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org"
target="_blank" moz-do-not-send="true">postgis-users@lists.osgeo.org</a><br>
<a
href="https://lists.osgeo.org/mailman/listinfo/postgis-users"
rel="noreferrer" target="_blank"
moz-do-not-send="true">https://lists.osgeo.org/mailma<wbr>n/listinfo/postgis-users</a></blockquote>
</div>
</blockquote>
</div>
<br>
<fieldset></fieldset>
<pre>______________________________<wbr>_________________
postgis-users mailing list
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank" moz-do-not-send="true">postgis-users@lists.osgeo.org</a>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank" moz-do-not-send="true">https://lists.osgeo.org/<wbr>mailman/listinfo/postgis-users</a></pre>
</blockquote>
</div>
</blockquote>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<pre class="moz-signature" cols="72">--
Med venlig hilsen / Kind regards
Bo Victor Thomsen
</pre>
</body>
</html>