Average Ratings 0 Ratings
Average Ratings 0 Ratings
Description
EMS DB Extract for PostgreSQL stands out as a powerful yet user-friendly solution for generating backups of PostgreSQL databases in the format of SQL scripts. This utility is designed to capture the metadata of all database objects alongside the actual table data, creating a comprehensive snapshot of the database. It ensures that the scripts are generated in the appropriate sequence, taking into account their dependencies. With options for extensive customization, users can choose which objects and tables to include in their dumps and adjust various settings to suit their needs. The tool also features a graphical wizard that provides a step-by-step guide through the extraction process, as well as a command-line interface for quick backups with a single command. Additionally, it offers the capability to extract database objects in dependency order, as well as options for compressing the output script and dividing it into smaller volumes for easier management. This makes EMS DB Extract for PostgreSQL an invaluable asset for anyone looking to secure their database efficiently.
Description
PostGIS serves as an extension for the PostgreSQL object-relational database, enhancing its capabilities with spatial features that enable the execution of geographic queries in SQL. Beyond just fundamental location functionalities, it provides a variety of advanced tools and features that are less common in other spatial databases like Oracle Locator/Spatial and SQL Server. Additionally, with PostgreSQL 14, PostGIS can take advantage of the improved GiST building support API, which significantly boosts performance. When compiled with the latest GEOS 3.10.1, users can benefit from enhancements in the ST_MakeValid function along with various speed optimizations, making it a powerful choice for handling spatial data effectively. This ensures that developers and analysts can work with geospatial data in a more efficient and streamlined manner.
API Access
Has API
No
API Access
Has API
No
Integrations
PostgreSQL
Yes
Azure Database for PostgreSQL
No
IBM Db2
Yes
InterBase
Yes
MySQL
Yes
Oracle Database
Yes
SQL Server
Yes
Integrations
PostgreSQL
Yes
Azure Database for PostgreSQL
Yes
IBM Db2
No
InterBase
No
MySQL
No
Oracle Database
No
SQL Server
No
Pricing Details
No price information available.
Free Trial
No
Free Version
No
Pricing Details
No price information available.
Free Trial
No
Free Version
No
Deployment
Web-Based
Yes
On-Premises
No
iPhone App
No
iPad App
No
Android App
No
Windows
No
Mac
No
Linux
No
Chromebook
No
Deployment
Web-Based
No
On-Premises
No
iPhone App
No
iPad App
No
Android App
No
Windows
Yes
Mac
Yes
Linux
Yes
Chromebook
No
Customer Support
Business Hours
Yes
Live Rep (24/7)
No
Online Support
Yes
Customer Support
Business Hours
No
Live Rep (24/7)
No
Online Support
Yes
Types of Training
Training Docs
Yes
Webinars
No
Live Training (Online)
No
In Person
No
Types of Training
Training Docs
Yes
Webinars
No
Live Training (Online)
No
In Person
No
Vendor Details
Company Name
EMS Software
Founded
1986
Country
United States
Website
www.sqlmanager.net/products/postgresql/extract
Vendor Details
Company Name
PostGIS
Website
postgis.net
Product Features
Database Backup
Automatic Backup
No
Backup Locations
No
Backup Scope Settings
No
Differential Backup
No
Filegroup Backup
No
Full Backup
No
Incremental Backup
No
Manual Backup
No
Multiple Backups
No
Product Features
GIS
3D Imagery
No
Census Data Integration
No
Color Coding
No
Geocoding
No
Image Exporting
No
Image Management
No
Internet Mapping
No
Interoperability
No
Labeling
No
Map Creation
No
Map Sharing
No
Near-Matching
No
Reverse Geocoding
No
Spatial Analysis
No