Manifold/PostGIS 数据操作和导出
我目前正在使用 Manifold Ultimate 开发 GIS 数据库项目。 我可以通过数据库控制台从 PostGIS 导入数据，并在 Manifold 中将数据编辑为表对象。
- 我如何将这些更改“提交”回 PostGIS？
- 我需要提交导出的数据库。 PostGIS 导出需要什么格式以及导出是如何完成的？
I'm currently working on a GIS database project using Manifold Ultimate.
I am able to import data from PostGIS via the database console, and edit the data as a table object within Manifold.
- How do i 'commit' these changes back to PostGIS?
- I am required to submit the exported database. What format is expected for a PostGIS export and how is the exporting done?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
@mdsumner 是正确的。链接 PostGIS 数据是可行的方法。
如果您已导出完整的表格并编辑记录，则通过新导出替换 PostGIS 中存在的数据并不简单。直到您删除了所有具有索引、触发器和序列的表（这些表的名称源自导出图形的相同名称（小写处理不一致）），此操作才会失败。仅仅放下桌子是不够的。
请注意，使用 Manifolds 链接存储模型，您没有在事务提交过程中写回的已编辑、添加或删除记录的客户端缓冲区。每列的每次编辑都会立即写入 PostGIS。
关于你的第二个问题：这取决于目标系统。 Manifold 导出 GEOMETRY 类型的几何图形。其他 PostGIS 客户端可能仅消化单一类型的点、线或多边形。只要您仅将一种类型的对象添加到绘图中，就可以编辑“geometry_columns.type”中的类型。
@mdsumner is correct. Linking the PostGIS data is the way to go.
If you have exported the complete table and edited records it's not simple to replace the data present in PostGIS by a new export. This will fail until you have deleted all the tables with index, triggers and sequences whose names are derived from the same name of exported drawing (with inconsistend handling of lower case). It's not enought to drop the table.
Note that with Manifolds linked storage model you have no client buffer of edited, added or deleted records that are written back in a process of commitment of a transaction. Every edit of every single column is written to PostGIS at once.
Concerning your 2. question: That depends on the target system. Manifold exports GEOMETRY type geometries. Other PostGIS clients may digest only a single type point, line or polygon. You can edit the type in "geometry_columns.type" as long as you have added only the one type of object to the drawing.
我认为，如果您导入了数据，它就不再链接到数据库，您需要将其导出并替换数据库中的内容。如果链接数据，则所做的编辑将“实时”提交，因为数据不是副本，而是由数据库存储。
我对此不太熟悉，但这就是帮助中的数据库控制台主题所描述的内容。
I think that if you imported the data it is no longer linked to the DB and you would need to export it and replace what is in the DB. If you link the data the edits you make are commited "live" as the data is not a copy but remains stored by the DB.
I'm not that familiar with this, but that's what the Database Console topic in help describes.