Postico A Modern Postgresql Client 1 5 10

1. Postico A Modern Postgresql Client 1 5 101
2. Postico A Modern Postgresql Client 1 5 1000
3. Postico A Modern Postgresql Client 1 5 100

Postico offers a user-friendly interface, which makes Postgres more accessible for both newcomers and specialists. Postico be familiar to anyone who has used a Mac before. Simply connect to a database and start working with tables and views. Start with the basics and learn about the advanced features of PostgreSQL as you go. Postico is an intuitive application. Description License Pricing Publisher; Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automaticaly and extracts its structure or data, it then generates SQL scripts that you can load into your PostgreSQL database. Postico 1.5.14 – A modern PostgreSQL Client. Start with the basics and learn about advanced features of PostgreSQL as you go along. Postico is an intuitive app. Postico is a Modern PostgreSQL Client for the Mac. Version 1.5.10 was released on Oct 3, 2019. Read the Changelist. Also available on the Mac App Store.

This page is a list of miscellaneous utilities that work with Postgres (ex: data loaders, comparators etc.). Things that don't do queries' 'enter SQL and get it back out again.'

If you'd like to find clients that allows you to 'enter SQL and get it back out again' see PostgreSQL Clients.

If you'd like to find DB visualization or design tools see Design Tools.

• 1Open Source / Free Software
• 2Proprietary

Open Source / Free Software

This is the list of 'open source and free' miscellaneous utilities:

Libre Office

Supports MySQL/MariaDB, Adabas D, MS Access and PostgreSQL, as well as other JDBC/ODBC databases.

PASH-Viewer: PostgreSQL Active Session History Viewer

Java (multi-platform).

Open-source software which provides graphical view of active session history and help you to answer questions like 'What wait events were taking most time?', 'Which sessions were taking most time?', 'Which queries were taking most time and what were they doing?'. It also supports Active Session History extension by pgsentinel. Does not do DB inserts, modifications, etc.

pgrights: GUI for PostgreSQL roles, privileges and policies

MacOS (based on Electron, so versions for other OS can be build from source code).

Open-source software which allows you to easily understand what can do (and what can't) a PostgreSQL user with a table's data. In other words, it's a viewer of results of GRANT commands and row-level security rules applied for a particular table and for a particular role. Only modifies user rights, no other capability.

Sohag Developer

Gnu/Linux Windows (Other OS can compile from source code).

Build a powerful database applications following few steps using Sohag Developer .Sohag Developer currently supports PostgreSQL database and has a set of CRUD generators that generates (Qt/C++ code and ui forms - PHP web applications uses web forms and bootstrap framework ) to manipulate the data in the database tables or views.

Beekeeper Studio

Beekeeper Studio is a modern cross-platform SQL editor and database manager available for Linux, Mac, and Windows. Some of its features include:

• Clean, smooth, usable UI with dark and light themes
• Tabbed Interface
• Multiple connections at the same time
• Saved queries and run history
• Auto-complete

Proprietary

This is a list of 'closed source' projects, some might have some manner of free version.

Access

Windows

Yes, you can use MS Access as a PostgreSQL database interface. Supports data access to PostgreSQL tables and views; many ODBC-based limitations and errors.

dbForge Studio for PostgreSQL

Microsoft Windows 2000/XP/2003/Vista and Windows 7, 8, 10

dbForge Studio for PostgreSQL by Devart is a GUI tool for database development and management. The IDE for PostgreSQL allows users to create, develop, and execute queries, edit and adjust the code to their requirements in a convenient and user-friendly interface. The tool also provides functionality for PostgreSQL data reporting, data editing, data import and export, building pivot tables and master-detail relations.

Key features:

• SQL Development - creating and editing queries, SQL Code Formatter;
• Query Profiler - locating bottlenecks & tuning performance of slow SQL queries;
• Data Editor - table settings management;
• Database Explorer - object tree navigation;
• Data Export and Data Import - 10+ widely used data formats;
• Pivot Table - grouping and summarizing data;
• Master-Detail Browser - data analysis and location of specific records & logical errors;
• Data Reports - build visual PostgreSQL data reports in 9 different formats.

dbForge Data Compare for PostgreSQL

Microsoft Windows 2000/XP/2003/Vista and Windows 7, 8, 10

dbForge Data Compare for PostgreSQL by Devart is a tool for table data comparison and synchronization. When using PostgreSQL data compare tool developer can detect data differences in compared PostgreSQL tables; generate data synchronization script and execute it to eliminate all these differences.

Key features:

• Identify the differences between two databases
• Compare separate tables or table groups by table name mask
• Compare tables with different structure
• Generate a report embodying data diff and save it for further analysis
• Sync data in tables and views in full or in part
• Generate SQL script for database synchronization
• Organize database synchronization according to the schedule

dbForge Schema Compare for PostgreSQL

Microsoft Windows 2000/XP/2003/Vista and Windows 7, 8, 10

dbForge Schema Compare for Amazon Redshift and PostgreSQL is a tool for easy and effective comparison and deployment of Redshift database structure differences. The tool gives a comprehensive view of all differences in Amazon Redshift database schemas and generates clear and accurate SQL synchronization scripts to update the database schemas.

Key features:

• Diff and sync Redshift databases quickly and efficiently
• Generate SQL scripts to update one database with the contents of another
• Apply updates from development databases to staging or production
• Compare the structure of Amazon Redshift databases and fix the errors
• Migrate PostgreSQL schemas to Amazon Redshift
• Automate routine synchronization tasks with command-line interface

TablePlus

macOS, Windows, iOS

TablePlus is a modern, native tool with elegant UI that allows you to simultaneously manage multiple databases such as MySQL, PostgreSQL, SQLite, Microsoft SQL Server and more.

• True native built.
• Workspace supports multiple tabs, multiple windows
• Powerful SQL editor with full features: auto syntax highlight, auto-suggestion, split pane, favorite and history.
• Data Filter & Sorting, import & export
• Full-dark theme & modern shortcut
• With plugin system, you can be able to write your own new features to work with database per your needs (export charts, pretty json…).

WaveMaker Ajax GUI Design Tool

Windows, Macintosh, Linux

WaveMaker is an Ajax-based GUI design tool for Postgres. WaveMaker is built using itself! WaveMaker generates a standard Java WAR file based on Spring, Hibernate and Dojo. WaveMaker supports Postgres schema creation and import and includes a visual query editor.

Postgres Compare

Windows, Mac & Linux

A comprehensive tool for identifying the differences between databases and generating an update script to synchronize them. Postgres Compare reads the system catalogs to determine the structure of the database and compares it to another to find the changes. Generate SQL and deploy the alterations, save snapshots for later. Automate the process via the command line.

Full Convert

Database conversion and synchronization between PostgreSQL and Microsoft Access, dBase, FoxPro, Microsoft Excel, Firebird, Interbase, MySQL, Oracle, Paradox, Microsoft SQL Server, SQL Server, SQL Server Azure, SQL Server Compact(SQLCE), SQLite, Delimited text files (CSV), XML and many more via ODBC.

Abris Platform

Web Application for Linux/Windows, requires Apache+PHP or Docker

Abris Platform is an application development platform for creating Web-based front-ends for PostgreSQL databases. Can be used to quickly create applications with convenient forms via SQL declarative description.

Key features:

• Quick setup - Abris Platform provides built-in means for flexible data structures configuration (tables, fields and relations). This can be done during system initialization as well as during system expluatation.
• Single page application - Related entities and tables are instantly accessible for view and edit on the same screen.
• Search - Use general in-table search and complex column filters.
• Charts - Data can be represented via charts of different types: bar charts, pie charts, lines any many others.
• Maps - Build-in support for geo data. Abris platform allow to vizualize geo-data event in real-time using OpenStreet Map package.
• Reporting - Filter settings can be saved as a report description and data can be exported in the following formats: HTML, PDF, Excel.
• Data import - Insert data in the current open list view from the computer clipboard.
• Notifications - Notification pool, that can be filled in PostgreSQL functions.
• Administrative tool - Built in administrative tools take care of user management, activity monitoring and auditing and allow to configure user/group access policy on the table and field database level.

Replicator Pro

Replicator allows table data comparison and sync - even with heterogeneous databases. It is unique in the fact it can replicate changes only even if source is non-relational (CSV, DBF, Excel documents, Paradox..). Replicator has a built-in scheduler for easy periodic change replication.

DBTools Manager

Windows

Admin

Freeware, available for PostgreSQL and MySQL, allows managing all aspects of the database: db, table, triggers, functions, etc. Includes import/export wizards to migrate data and structure to/from other database engines. Developed by DBTools Software.

PostgreSQL PHP Generator

Windows

PostgreSQL PHP Generator is a freeware but powerful PostgreSQL GUI frontend that allows you to generate high-quality PHP scripts for the selected tables, views and queries for the further working with these objects through the web.

ConvertDB for PosttgreSQL

http://convertdb.com/postgresql has PostgreSQL export/ import tools

Windows

The software is able to connect to remote PostgreSQL 9.x/7.4 located on Linux, Solaris, Mac OS X, and Windows.

ConvertDB cross-database migration tools assist in data conversion and synchronization among PostgreSQL, MySQL, MS SQL Server, MS Windows SQL Azure, and MS Access databases

• 1 Million of records can be transferred in 5-10 minutes.
• Bi-directional synchronization between PostgreSQL, MS SQL, MySQL and Oracle
• Scheduling migration and synchronization jobs.

dotConnect for PostgreSQL

Windows

dotConnect for PostgreSQL, formerly known as PostgreSQLDirect .NET, is an enhanced ORM enabled data provider for PostgreSQL that builds on ADO.NET technology to present a complete solution for developing PostgreSQL-based database applications. It introduces new approaches for designing application architecture, boosts productivity, and leverages database applications.

Key features:

• Direct Mode
• Database Application Development Extension
• PostgreSQL Advanced Features Support
• Optimized Code
• ORM Support
• BIS Support

Devart PostgreSQL Data Access Components

Windows

PostgreSQL Data Access Components (PgDAC) is a library of components that provides native connectivity to PostgreSQL from Delphi, C++Builder, Lazarus (and Free Pascal) on Windows, Mac OS X, iOS, Android, Linux, and FreeBSD for both 32-bit and 64-bit platforms. PgDAC is designed to help programmers develop really lightweight, faster and cleaner PostgreSQL database applications without deploying any additional libraries.

Native Connectivity to PostgreSQLPgDAC is a complete replacement for standard PostgreSQL connectivity solutions and presents an efficient alternative to the Borland Database Engine (BDE) and standard dbExpress driver for access to PostgreSQL. It provides direct access to PostgreSQL without PostgreSQL Client.

Devart ODBC Driver for PostgreSQL

Windows

Devart ODBC Driver for PostgreSQL provides high-performance and feature-rich connectivity solution for ODBC-based applications to access PostgreSQL databases from Windows, both 32-bit and 64-bit. Full support for standard ODBC API functions and data types implemented in our driver makes the interaction of your database applications with PostgreSQL fast, easy and extremely handy.

Devart Excel Add-in for PostgreSQL

Windows

Devart Excel Add-in for PostgreSQL allows you to quickly and easily connect Microsoft Excel to PostgreSQL, load data from PostgreSQL to Excel, instantly refresh data in an Excel workbook from the database, edit these data, and save them back to PostgreSQL. It enables you to work with PostgreSQL data like with usual Excel worksheets, easily perform data cleansing and de-duplication, and apply all the Excel's powerful data processing and analysis capabilities to these data.

EMS Database Management Tools for PostgreSQL

Windows

PostgreSQL Tools Products Family:

• EMS SQL Manager for PostgreSQL see PostgreSQL Clients.

• SQL Management Studio for PostgreSQL - a single workbench for administering PostgreSQL databases, managing database schema and objects as well as for database design, migration, extraction, query building, data import, export, and database comparison.

• SQL Manager for PostgreSQL - high performance graphical tool for PostgreSQL database administration and development. It makes creating and editing PostgreSQL database objects easy and fast, and allows you to run SQL scripts, visually design databases, build SQL queries, extract, print and search metadata, import and export PostgreSQL database data and much more.

• Data Export for PostgreSQL - tool to export PostgreSQL database data quickly to any of 19 available formats, including MS Access, MS Excel, MS Word, RTF, HTML, TXT, ODF and more. Data Export for PostgreSQL has a kata kata lucu friendly wizard, which allows you to set various options of PostgreSQL export process visually and a command-line utility to automate your PostgreSQL export jobs using the configuration file.

• Data Import for PostgreSQL - tool to import data to PostgreSQL tables from MS Excel 97-2007, MS Access, DBF, TXT, CSV, MS Word 2007, RTF, ODF and HTML files. This utility allows you to quickly import data to one or several PostgreSQL tables or views at once, save all PostgreSQL import parameters set on current wizard session, use special batch insert mode to import PostgreSQL data at the maximum possible speed and much more.

• Data Pump for PostgreSQL - migration tool for converting databases and importing table data from an ADO-compatible source (e.g. MS Access, MS SQL database or any other database with ADO support) to PostgreSQL databases.

• Data Generator for PostgreSQL - tool for generating test data to PostgreSQL database tables. The utility can help you to simulate the database production environment and allows you to populate several PostgreSQL database tables with test data simultaneously, define tables for generating data, set value ranges, control a wide variety of generation parameters for each field type and much more.

• DB Comparer for PostgreSQL - a tool for comparing PostgreSQL database schemas and discovering differences in their structures. You can view all the differences in compared database objects and execute an automatically generated script to synchronize structure of PostgreSQL databases and eliminate these differences.

• DB Extract for PostgreSQL - easy-to-use tool for creating PostgreSQL database backups in a form of SQL scripts. This database script utility allows you to save metadata of all PostgreSQL database objects as well as PostgreSQL table data as database snapshots.

• SQL Query for PostgreSQL - a useful tool that lets you quickly and simply build SQL queries to PostgreSQL databases. Visual PostgreSQL query building, as well as direct editing of a query text, is available.

• Data Comparer for PostgreSQL - tool for PostgreSQL data comparison and synchronization. Using this utility you can view all the differences in compared PostgreSQL tables and execute an automatically generated script to eliminate these differences.

SQL Maestro Group products for PostgreSQL

Windows

SQL Maestro Group offers a number of tools for PostgreSQL.

• Maestro for PostgreSQL see PostgreSQL Clients.

• PostgreSQL Data Wizard provides you with a number of easy-to-use wizards to transfer any database to PostgreSQL, export data from PostgreSQL tables, views and queries to most popular formats, and import data from various sources into PostgreSQL tables.

• PostgreSQL Code Factory is a GUI tool aimed at the SQL queries and scripts development.

• PostgreSQL Data Sync is a powerful and easy-to-use tool for database contents comparison and synchronization.

• PostgreSQL PHP Generator Professional is a frontend that allows you to generate high-quality PHP applications for your database in a few mouse clicks.

SQL Maestro Group also produces similar tools for MySQL, Oracle, MS SQL Server, SQLite, Firebird, DB2, SQL Anywhere, and MaxDB.

Datanamic DataDiff for PostgreSQL

Windows

Datanamic DataDiff for PostgreSQL is a utility for data comparison and synchronization. Compare data for selected tables in two databases, view differences and publish changes quickly and safely. Flexible comparison and synchronization settings will enable you to set up a customized comparison key and to select tables and fields for comparison and for synchronization.DB Data Difftective can be used for data migrations, verification of (corrupt) data, data auditing etc.

Datanamic SchemaDiff for PostgreSQL

Windows

Datanamic SchemaDiff for PostgreSQL is a tool for comparison and synchronization of database schemas. It allows you to compare and synchronize tables, views, functions, sequences (generators), stored procedures, triggers and constraints between two databases.

DB MultiRun PostgreSQL Edition

Windows

DB MultiRun is a simple tool to execute multiple SQL scripts on multiple databases quickly.Define a list of databases, add SQL scripts to execute on these databases and click 'execute' to run those scripts on the databases in the list. The multi-threaded execution of the SQL scripts makes it complete the task fast. After execution of the scripts, you can examine the results of the executed scripts on each database.

DB Doc for PostgreSQL

Windows

DB Doc helps you document your database schema and generate shareable PDF, HTML, XML, and Microsoft Word document in only 5 steps. Furthermore, the layout of the generated documents are customizable.

SQL Blob Export

Windows

SQL Blob Export exports unlimited images and files from your tables or queries in 5 simple steps.

SQL File Import

Windows

SQL File Import allows you to upload files, images, and other data into your database, without having to write any SQL statements. SQL File Import supports PostgreSQL, Firebird, MySQL, Oracle, SQLite, SQL Server, and various ODBC-supported databases (e.g. DB2 and PostgreSQL).

A scripting engine allows you to transform data before importing them into your database. A command line version is also included to allow you to perform unattended upload/import tasks.

SQL Image Viewer

Windows

SQL Image Viewer allows you to retrieve, view, convert and export images stored in Firebird, MySQL, Oracle, SQLite, SQL Server, and various ODBC-supported databases (e.g. DB2 and PostgreSQL). It supports the following image formats: BMP, GIF, JPG, PNG, PSD, and TIFF.

It also allows you to export binary data and recognises the following binary file types: PDF, MP3, WAV, 7Z, BZ2, GZ, RAR, ZIP, and has experimental support for DOC, PPT and XLS file types.

A command line version is also included to allow you to perform unattended scheduled exports of binary data.

SQL Multi Select

Windows

SQL Multi Select is a query tool that allows you to run multiple scripts on multiple servers with a single click. Result sets from different servers are consolidated into a single view, allowing for easy comparison and analysis.

Devart SSIS Data Flow Components for PostgreSQL

Windows

Devart SSIS Data Flow Components for PostgreSQL allow you to integrate database and cloud data via SQL Server Integration Services (SSIS).

Devart SSIS Data Flow Components provide easy to set up cost-effective data integration using SSIS ETL engine. They provide high performance data loading, convenient component editors, SQL support for cloud data sources and lots of data source specific features.

EDB Postgres Enterprise Manager

Windows, Mac OS X, Linux

Postgres Enterprise Manager is the only solution available today that allows you to intelligently manage, monitor, and tune large scale Postgres installations from a single GUI console.

Monitoring features include: server auto-discovery, over 225 pre-configured ready to run probes, custom probes, alert management, personalized alerts, remote monitoring, versatile charting, custom dashboards and web client.

DBA tools include: database objects management, Postgres Expert (best practice configuration settings), Audit Manager, Log Manager, Log Analysis Expert, Capacity Manager and Team Support.

Developer tools include: Query Tool, Data Grid, SQL Profiler, SQL Debugger and Import tools.

Tuning tools include: At-A-Glance performance dashboards, Tuning Wizard, Performance Diagnostics and Index Advisor.

ClusterControl by Severalnines

ClusterControl is an all-inclusive open source database management system that allows you to deplore, monitor, manage and scale your database environments. ClusterControl provides the basic functionality you need to get PostgreSQL up-and-running using our deployment wizard, monitoring and basic management abilities like automatic failover, backups, and restores.

• Point and Click Replication Deployments - ClusterControl allows you to easily deploy and configure master/slave replication PostgreSQL instances.
• Advanced Performance Monitoring - ClusterControl monitors queries and detects anomalies with built-in alerts.
• Automated Failover Handling - ClusterControl detects master failures and automatically promotes a new master
• Database Automation - ClusterControl lets you manage configurations, schedule, and restore backups.

Reportizer

Reportizer is a database reporting tool, which allows easy creating, modifying, and printing database reports from different types of databases, including PostgreSQL. Reports can be edited in convenient visual report builder or in text mode. It supports calculating fields, multi-column reports, expressions, grouping, displaying images etc. Reportizer can export reports to HTML, XLSX, image, or internal format. There is an ability to load and print reports from command line. Reportizer allows to manage report collections, which can be held either in files or in database tables.

Exportizer Enterprise

Exportizer Enterprise is a database export tool, which can work with PostgreSQL database either as source or destination. It allows to export data to database, file, clipboard, or printer.

• Possible sources: ODBC data sources, files of DB (Paradox), DBF (dBase, FoxPro), MDB, ACCDB, XLS, XLSX, GDB, IB, FDB, HTML, UDL, DBC, TXT, CSV types, databases specified by ADO connection strings, and databases like Oracle, SQL Server, PostgreSql, DB2, Informix, SQLite, Interbase etc.
• Possible destinations: file formats like text, CSV, XLS, XLSX, RTF, XML, HTML, PDF, DBF, SLK, SQL script, and relational database of any supported type including PostgreSQL.
• It is possible to export all or selected tables from an open database at once.
• The data migration can be done in super-fast batch mode.
• Exportizer Enterprise can automatically detect the most known image types (JPEG, PNG, GIF, BMP, ICO) in BLOB fields and export them, for example, to HTML or XLSX.
• Images and other BLOB data can be exported to multiple separate files during a single export operation.
• There is an ability to specify the source-to-target field mappings.
• Export operations can be performed either via the program interface or via command line.

TiCodeX SQL Schema Compare

TiCodeX SQL Schema Compare is a tools that allows database administrators to compare multiple database schema in order to manage versioning.
The software runs on Windows, Linux and Mac and supports Microsoft SQL (MS-SQL), MySQL, PostgreSQL, Azure SQL and MS-SQL on Amazon RDS.

Key Features:

• Runs on Windows, Linux and MacOS
• Localized in English, German and Italian
• Compare changes between two SQL Database schemas (as example from development to test to production)
• View database differences and explore schema changes to see what's going on
• Automatically create full database migration scripts
• Securely save database and server login details

pgMustard

pgMustard is a performance tool for PostgreSQL that provides a user interface for your EXPLAIN ANALYSE output, as well as tips on what to do to speed up your query.

Features:

• Quickly see the slowest operations
• Code snippets to tie operations back to the query
• Tips to speed up your query💡
• Does the arithmetic for you (including wall clock times)
• Explanations of operation types and key concepts
• Links to relevant documentation and blog posts

Requirements:

• JSON format plans
• Any supported version of PostgreSQL
• English language only
• Web application, no installation required

ODBC Driver for PostgreSQL by CData

The CData ODBC Driver for PostgreSQL enables real-time access to PostgreSQL data, directly from any applications that support ODBC connectivity, the most widely supported interface for connecting applications with data. The driver wraps the complexity of accessing PostgreSQL data in a standard ODBC driver compliant with ODBC 3.8. The driver hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.

JDBC Driver for PostgreSQL by CData

The CData JDBC Driver for PostgreSQL offers the most natural way to connect to PostgreSQL data from Java-based applications and developer technologies. The driver wraps the complexity of accessing PostgreSQL data in an easy-to-integrate, 100%-Java JDBC driver. The driver hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.

Postico A Modern Postgresql Client 1 5 101

ADO.NET Provider for PostgreSQL by CData

The CData ADO.NET Provider for PostgreSQL offers the most natural way to access PostgreSQL data from .NET applications. The provider wraps the complexity of accessing PostgreSQL data in an easy-to-integrate, fully managed ADO.NET Data Provider.The provider hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.

Excel Add-In for PostgreSQL by CData

The CData Excel Add-In provides the easiest way to connect to PostgreSQL data from Excel. From the CData ribbon, you can select PostgreSQL data as tables and columns into the spreadsheet. The spreadsheet is then linked with the remote data. To update the data, edit the spreadsheet.

SSIS Components for PostgreSQL by CData

The CData SSIS Components for PostgreSQL enable you to connect SQL Server with PostgreSQL data through SSIS Workflows. The components wrap the complexity of accessing PostgreSQL data in standard SSIS data flow components. You can then connect and synchronize PostgreSQL tables with SQL Server tables.The components hide the complexity of accessing data and provide additional security features, smart caching, batching, socket management, and more.

Power BI Connector for PostgreSQL by CData

The CData Power BI Connector for PostgreSQL offers self-service integration with Microsoft Power BI. The connector facilitates live access to PostgreSQL data in Power BI from the Get Data window. The connector also provides direct querying to visualize and analyze PostgreSQL data.

Other Resources

Web Application for Linux/Windows, requires Apache+PHP or Docker

Abris Platform is an application development platform for creating Web-based front-ends for PostgreSQL databases. Can be used to quickly create applications with convenient forms via SQL declarative description.

Key features:

• Quick setup - Abris Platform provides built-in means for flexible data structures configuration (tables, fields and relations). This can be done during system initialization as well as during system expluatation.
• Single page application - Related entities and tables are instantly accessible for view and edit on the same screen.
• Search - Use general in-table search and complex column filters.
• Charts - Data can be represented via charts of different types: bar charts, pie charts, lines any many others.
• Maps - Build-in support for geo data. Abris platform allow to vizualize geo-data event in real-time using OpenStreet Map package.
• Reporting - Filter settings can be saved as a report description and data can be exported in the following formats: HTML, PDF, Excel.
• Data import - Insert data in the current open list view from the computer clipboard.
• Notifications - Notification pool, that can be filled in PostgreSQL functions.
• Administrative tool - Built in administrative tools take care of user management, activity monitoring and auditing and allow to configure user/group access policy on the table and field database level.

Replicator Pro

Replicator allows table data comparison and sync - even with heterogeneous databases. It is unique in the fact it can replicate changes only even if source is non-relational (CSV, DBF, Excel documents, Paradox..). Replicator has a built-in scheduler for easy periodic change replication.

DBTools Manager

Windows

Admin

Freeware, available for PostgreSQL and MySQL, allows managing all aspects of the database: db, table, triggers, functions, etc. Includes import/export wizards to migrate data and structure to/from other database engines. Developed by DBTools Software.

PostgreSQL PHP Generator

Windows

PostgreSQL PHP Generator is a freeware but powerful PostgreSQL GUI frontend that allows you to generate high-quality PHP scripts for the selected tables, views and queries for the further working with these objects through the web.

ConvertDB for PosttgreSQL

http://convertdb.com/postgresql has PostgreSQL export/ import tools

Windows

The software is able to connect to remote PostgreSQL 9.x/7.4 located on Linux, Solaris, Mac OS X, and Windows.

ConvertDB cross-database migration tools assist in data conversion and synchronization among PostgreSQL, MySQL, MS SQL Server, MS Windows SQL Azure, and MS Access databases

• 1 Million of records can be transferred in 5-10 minutes.
• Bi-directional synchronization between PostgreSQL, MS SQL, MySQL and Oracle
• Scheduling migration and synchronization jobs.

dotConnect for PostgreSQL

Windows

dotConnect for PostgreSQL, formerly known as PostgreSQLDirect .NET, is an enhanced ORM enabled data provider for PostgreSQL that builds on ADO.NET technology to present a complete solution for developing PostgreSQL-based database applications. It introduces new approaches for designing application architecture, boosts productivity, and leverages database applications.

Key features:

• Direct Mode
• Database Application Development Extension
• PostgreSQL Advanced Features Support
• Optimized Code
• ORM Support
• BIS Support

Devart PostgreSQL Data Access Components

Windows

PostgreSQL Data Access Components (PgDAC) is a library of components that provides native connectivity to PostgreSQL from Delphi, C++Builder, Lazarus (and Free Pascal) on Windows, Mac OS X, iOS, Android, Linux, and FreeBSD for both 32-bit and 64-bit platforms. PgDAC is designed to help programmers develop really lightweight, faster and cleaner PostgreSQL database applications without deploying any additional libraries.

Native Connectivity to PostgreSQLPgDAC is a complete replacement for standard PostgreSQL connectivity solutions and presents an efficient alternative to the Borland Database Engine (BDE) and standard dbExpress driver for access to PostgreSQL. It provides direct access to PostgreSQL without PostgreSQL Client.

Devart ODBC Driver for PostgreSQL

Windows

Devart ODBC Driver for PostgreSQL provides high-performance and feature-rich connectivity solution for ODBC-based applications to access PostgreSQL databases from Windows, both 32-bit and 64-bit. Full support for standard ODBC API functions and data types implemented in our driver makes the interaction of your database applications with PostgreSQL fast, easy and extremely handy.

Devart Excel Add-in for PostgreSQL

Windows

Devart Excel Add-in for PostgreSQL allows you to quickly and easily connect Microsoft Excel to PostgreSQL, load data from PostgreSQL to Excel, instantly refresh data in an Excel workbook from the database, edit these data, and save them back to PostgreSQL. It enables you to work with PostgreSQL data like with usual Excel worksheets, easily perform data cleansing and de-duplication, and apply all the Excel's powerful data processing and analysis capabilities to these data.

EMS Database Management Tools for PostgreSQL

Windows

PostgreSQL Tools Products Family:

• EMS SQL Manager for PostgreSQL see PostgreSQL Clients.

• SQL Management Studio for PostgreSQL - a single workbench for administering PostgreSQL databases, managing database schema and objects as well as for database design, migration, extraction, query building, data import, export, and database comparison.

• SQL Manager for PostgreSQL - high performance graphical tool for PostgreSQL database administration and development. It makes creating and editing PostgreSQL database objects easy and fast, and allows you to run SQL scripts, visually design databases, build SQL queries, extract, print and search metadata, import and export PostgreSQL database data and much more.

• Data Export for PostgreSQL - tool to export PostgreSQL database data quickly to any of 19 available formats, including MS Access, MS Excel, MS Word, RTF, HTML, TXT, ODF and more. Data Export for PostgreSQL has a kata kata lucu friendly wizard, which allows you to set various options of PostgreSQL export process visually and a command-line utility to automate your PostgreSQL export jobs using the configuration file.

• Data Import for PostgreSQL - tool to import data to PostgreSQL tables from MS Excel 97-2007, MS Access, DBF, TXT, CSV, MS Word 2007, RTF, ODF and HTML files. This utility allows you to quickly import data to one or several PostgreSQL tables or views at once, save all PostgreSQL import parameters set on current wizard session, use special batch insert mode to import PostgreSQL data at the maximum possible speed and much more.

• Data Pump for PostgreSQL - migration tool for converting databases and importing table data from an ADO-compatible source (e.g. MS Access, MS SQL database or any other database with ADO support) to PostgreSQL databases.

• Data Generator for PostgreSQL - tool for generating test data to PostgreSQL database tables. The utility can help you to simulate the database production environment and allows you to populate several PostgreSQL database tables with test data simultaneously, define tables for generating data, set value ranges, control a wide variety of generation parameters for each field type and much more.

• DB Comparer for PostgreSQL - a tool for comparing PostgreSQL database schemas and discovering differences in their structures. You can view all the differences in compared database objects and execute an automatically generated script to synchronize structure of PostgreSQL databases and eliminate these differences.

• DB Extract for PostgreSQL - easy-to-use tool for creating PostgreSQL database backups in a form of SQL scripts. This database script utility allows you to save metadata of all PostgreSQL database objects as well as PostgreSQL table data as database snapshots.

• SQL Query for PostgreSQL - a useful tool that lets you quickly and simply build SQL queries to PostgreSQL databases. Visual PostgreSQL query building, as well as direct editing of a query text, is available.

• Data Comparer for PostgreSQL - tool for PostgreSQL data comparison and synchronization. Using this utility you can view all the differences in compared PostgreSQL tables and execute an automatically generated script to eliminate these differences.

SQL Maestro Group products for PostgreSQL

Windows

SQL Maestro Group offers a number of tools for PostgreSQL.

• Maestro for PostgreSQL see PostgreSQL Clients.

• PostgreSQL Data Wizard provides you with a number of easy-to-use wizards to transfer any database to PostgreSQL, export data from PostgreSQL tables, views and queries to most popular formats, and import data from various sources into PostgreSQL tables.

• PostgreSQL Code Factory is a GUI tool aimed at the SQL queries and scripts development.

• PostgreSQL Data Sync is a powerful and easy-to-use tool for database contents comparison and synchronization.

• PostgreSQL PHP Generator Professional is a frontend that allows you to generate high-quality PHP applications for your database in a few mouse clicks.

SQL Maestro Group also produces similar tools for MySQL, Oracle, MS SQL Server, SQLite, Firebird, DB2, SQL Anywhere, and MaxDB.

Datanamic DataDiff for PostgreSQL

Windows

Datanamic DataDiff for PostgreSQL is a utility for data comparison and synchronization. Compare data for selected tables in two databases, view differences and publish changes quickly and safely. Flexible comparison and synchronization settings will enable you to set up a customized comparison key and to select tables and fields for comparison and for synchronization.DB Data Difftective can be used for data migrations, verification of (corrupt) data, data auditing etc.

Datanamic SchemaDiff for PostgreSQL

Windows

Datanamic SchemaDiff for PostgreSQL is a tool for comparison and synchronization of database schemas. It allows you to compare and synchronize tables, views, functions, sequences (generators), stored procedures, triggers and constraints between two databases.

DB MultiRun PostgreSQL Edition

Windows

DB MultiRun is a simple tool to execute multiple SQL scripts on multiple databases quickly.Define a list of databases, add SQL scripts to execute on these databases and click 'execute' to run those scripts on the databases in the list. The multi-threaded execution of the SQL scripts makes it complete the task fast. After execution of the scripts, you can examine the results of the executed scripts on each database.

DB Doc for PostgreSQL

Windows

DB Doc helps you document your database schema and generate shareable PDF, HTML, XML, and Microsoft Word document in only 5 steps. Furthermore, the layout of the generated documents are customizable.

SQL Blob Export

Windows

SQL Blob Export exports unlimited images and files from your tables or queries in 5 simple steps.

SQL File Import

Windows

SQL File Import allows you to upload files, images, and other data into your database, without having to write any SQL statements. SQL File Import supports PostgreSQL, Firebird, MySQL, Oracle, SQLite, SQL Server, and various ODBC-supported databases (e.g. DB2 and PostgreSQL).

A scripting engine allows you to transform data before importing them into your database. A command line version is also included to allow you to perform unattended upload/import tasks.

SQL Image Viewer

Windows

SQL Image Viewer allows you to retrieve, view, convert and export images stored in Firebird, MySQL, Oracle, SQLite, SQL Server, and various ODBC-supported databases (e.g. DB2 and PostgreSQL). It supports the following image formats: BMP, GIF, JPG, PNG, PSD, and TIFF.

It also allows you to export binary data and recognises the following binary file types: PDF, MP3, WAV, 7Z, BZ2, GZ, RAR, ZIP, and has experimental support for DOC, PPT and XLS file types.

A command line version is also included to allow you to perform unattended scheduled exports of binary data.

SQL Multi Select

Windows

SQL Multi Select is a query tool that allows you to run multiple scripts on multiple servers with a single click. Result sets from different servers are consolidated into a single view, allowing for easy comparison and analysis.

Devart SSIS Data Flow Components for PostgreSQL

Windows

Devart SSIS Data Flow Components for PostgreSQL allow you to integrate database and cloud data via SQL Server Integration Services (SSIS).

Devart SSIS Data Flow Components provide easy to set up cost-effective data integration using SSIS ETL engine. They provide high performance data loading, convenient component editors, SQL support for cloud data sources and lots of data source specific features.

EDB Postgres Enterprise Manager

Windows, Mac OS X, Linux

Postgres Enterprise Manager is the only solution available today that allows you to intelligently manage, monitor, and tune large scale Postgres installations from a single GUI console.

Monitoring features include: server auto-discovery, over 225 pre-configured ready to run probes, custom probes, alert management, personalized alerts, remote monitoring, versatile charting, custom dashboards and web client.

DBA tools include: database objects management, Postgres Expert (best practice configuration settings), Audit Manager, Log Manager, Log Analysis Expert, Capacity Manager and Team Support.

Developer tools include: Query Tool, Data Grid, SQL Profiler, SQL Debugger and Import tools.

Tuning tools include: At-A-Glance performance dashboards, Tuning Wizard, Performance Diagnostics and Index Advisor.

ClusterControl by Severalnines

ClusterControl is an all-inclusive open source database management system that allows you to deplore, monitor, manage and scale your database environments. ClusterControl provides the basic functionality you need to get PostgreSQL up-and-running using our deployment wizard, monitoring and basic management abilities like automatic failover, backups, and restores.

• Point and Click Replication Deployments - ClusterControl allows you to easily deploy and configure master/slave replication PostgreSQL instances.
• Advanced Performance Monitoring - ClusterControl monitors queries and detects anomalies with built-in alerts.
• Automated Failover Handling - ClusterControl detects master failures and automatically promotes a new master
• Database Automation - ClusterControl lets you manage configurations, schedule, and restore backups.

Reportizer

Reportizer is a database reporting tool, which allows easy creating, modifying, and printing database reports from different types of databases, including PostgreSQL. Reports can be edited in convenient visual report builder or in text mode. It supports calculating fields, multi-column reports, expressions, grouping, displaying images etc. Reportizer can export reports to HTML, XLSX, image, or internal format. There is an ability to load and print reports from command line. Reportizer allows to manage report collections, which can be held either in files or in database tables.

Exportizer Enterprise

Exportizer Enterprise is a database export tool, which can work with PostgreSQL database either as source or destination. It allows to export data to database, file, clipboard, or printer.

• Possible sources: ODBC data sources, files of DB (Paradox), DBF (dBase, FoxPro), MDB, ACCDB, XLS, XLSX, GDB, IB, FDB, HTML, UDL, DBC, TXT, CSV types, databases specified by ADO connection strings, and databases like Oracle, SQL Server, PostgreSql, DB2, Informix, SQLite, Interbase etc.
• Possible destinations: file formats like text, CSV, XLS, XLSX, RTF, XML, HTML, PDF, DBF, SLK, SQL script, and relational database of any supported type including PostgreSQL.
• It is possible to export all or selected tables from an open database at once.
• The data migration can be done in super-fast batch mode.
• Exportizer Enterprise can automatically detect the most known image types (JPEG, PNG, GIF, BMP, ICO) in BLOB fields and export them, for example, to HTML or XLSX.
• Images and other BLOB data can be exported to multiple separate files during a single export operation.
• There is an ability to specify the source-to-target field mappings.
• Export operations can be performed either via the program interface or via command line.

TiCodeX SQL Schema Compare

TiCodeX SQL Schema Compare is a tools that allows database administrators to compare multiple database schema in order to manage versioning.
The software runs on Windows, Linux and Mac and supports Microsoft SQL (MS-SQL), MySQL, PostgreSQL, Azure SQL and MS-SQL on Amazon RDS.

Key Features:

• Runs on Windows, Linux and MacOS
• Localized in English, German and Italian
• Compare changes between two SQL Database schemas (as example from development to test to production)
• View database differences and explore schema changes to see what's going on
• Automatically create full database migration scripts
• Securely save database and server login details

pgMustard

pgMustard is a performance tool for PostgreSQL that provides a user interface for your EXPLAIN ANALYSE output, as well as tips on what to do to speed up your query.

Features:

• Quickly see the slowest operations
• Code snippets to tie operations back to the query
• Tips to speed up your query💡
• Does the arithmetic for you (including wall clock times)
• Explanations of operation types and key concepts
• Links to relevant documentation and blog posts

Requirements:

• JSON format plans
• Any supported version of PostgreSQL
• English language only
• Web application, no installation required

ODBC Driver for PostgreSQL by CData

The CData ODBC Driver for PostgreSQL enables real-time access to PostgreSQL data, directly from any applications that support ODBC connectivity, the most widely supported interface for connecting applications with data. The driver wraps the complexity of accessing PostgreSQL data in a standard ODBC driver compliant with ODBC 3.8. The driver hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.

JDBC Driver for PostgreSQL by CData

The CData JDBC Driver for PostgreSQL offers the most natural way to connect to PostgreSQL data from Java-based applications and developer technologies. The driver wraps the complexity of accessing PostgreSQL data in an easy-to-integrate, 100%-Java JDBC driver. The driver hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.

Postico A Modern Postgresql Client 1 5 101

ADO.NET Provider for PostgreSQL by CData

The CData ADO.NET Provider for PostgreSQL offers the most natural way to access PostgreSQL data from .NET applications. The provider wraps the complexity of accessing PostgreSQL data in an easy-to-integrate, fully managed ADO.NET Data Provider.The provider hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.

Excel Add-In for PostgreSQL by CData

The CData Excel Add-In provides the easiest way to connect to PostgreSQL data from Excel. From the CData ribbon, you can select PostgreSQL data as tables and columns into the spreadsheet. The spreadsheet is then linked with the remote data. To update the data, edit the spreadsheet.

SSIS Components for PostgreSQL by CData

The CData SSIS Components for PostgreSQL enable you to connect SQL Server with PostgreSQL data through SSIS Workflows. The components wrap the complexity of accessing PostgreSQL data in standard SSIS data flow components. You can then connect and synchronize PostgreSQL tables with SQL Server tables.The components hide the complexity of accessing data and provide additional security features, smart caching, batching, socket management, and more.

Power BI Connector for PostgreSQL by CData

The CData Power BI Connector for PostgreSQL offers self-service integration with Microsoft Power BI. The connector facilitates live access to PostgreSQL data in Power BI from the Get Data window. The connector also provides direct querying to visualize and analyze PostgreSQL data.

Other Resources

PostgreSQL Clients - list of UI's for accessing your db contents (enter sql, get back the results)

Design Tools - tools for designing and visualizing database schemas

Old possibly abandoned projects, see Community_Guide_to_PostgreSQL_Tools_Abandoned

The character set support in PostgreSQL allows you to store text in a variety of character sets (also called encodings), including single-byte character sets such as the ISO 8859 series and multiple-byte character sets such as EUC (Extended Unix Code), UTF-8, and Mule internal code. Screenflow 6 6 1. All supported character sets can be used transparently by clients, but a few are not supported for use within the server (that is, as a server-side encoding). The default character set is selected while initializing your PostgreSQL database cluster using initdb. It can be overridden when you create a database, so you can have multiple databases each with a different character set.

An important restriction, however, is that each database's character set must be compatible with the database's LC_CTYPE (character classification) and LC_COLLATE (string sort order) locale settings. For C or POSIX locale, any character set is allowed, but for other libc-provided locales there is only one character set that will work correctly. (On Windows, however, UTF-8 encoding can be used with any locale.) If you have ICU support configured, ICU-provided locales can be used with most but not all server-side encodings.

Table 23.1 shows the character sets available for use in PostgreSQL.

Table 23.1. PostgreSQL Character Sets

Not all client APIs support all the listed character sets. For example, the PostgreSQL JDBC driver does not support MULE_INTERNAL, LATIN6, LATIN8, and LATIN10.

The SQL_ASCII setting behaves considerably differently from the other settings. When the server character set is SQL_ASCII, the server interprets byte values 0-127 according to the ASCII standard, while byte values 128-255 are taken as uninterpreted characters. No encoding conversion will be done when the setting is SQL_ASCII. Thus, this setting is not so much a declaration that a specific encoding is in use, as a declaration of ignorance about the encoding. In most cases, if you are working with any non-ASCII data, it is unwise to use the SQL_ASCII setting because PostgreSQL will be unable to help you by converting or validating non-ASCII characters.

initdb defines the default character set (encoding) for a PostgreSQL cluster. For example,

sets the default character set to EUC_JP (Extended Unix Code for Japanese). You can use --encoding instead of -E if you prefer longer option strings. If no -E or --encoding option is given, initdb attempts to determine the appropriate encoding to use based on the specified or default locale.

Postico A Modern Postgresql Client 1 5 1000

You can specify a non-default encoding at database creation time, provided that the encoding is compatible with the selected locale:

This will create a database named korean that uses the character set EUC_KR, and locale ko_KR. Another way to accomplish this is to use this SQL command:

Notice that the above commands specify copying the template0 database. When copying any other database, the encoding and locale settings cannot be changed from those of the source database, because that might result in corrupt data. For more information see Section 22.3.

Postico A Modern Postgresql Client 1 5 100

The encoding for a database is stored in the system catalog pg_database. You can see it by using the psql-l option or the l command.

Important

On most modern operating systems, PostgreSQL can determine which character set is implied by the LC_CTYPE setting, and it will enforce that only the matching database encoding is used. On older systems it is your responsibility to ensure that you use the encoding expected by the locale you have selected. A mistake in this area is likely to lead to strange behavior of locale-dependent operations such as sorting.

PostgreSQL will allow superusers to create databases with SQL_ASCII encoding even when LC_CTYPE is not C or POSIX. As noted above, SQL_ASCII does not enforce that the data stored in the database has any particular encoding, and so this choice poses risks of locale-dependent misbehavior. Using this combination of settings is deprecated and may someday be forbidden altogether.

PostgreSQL supports automatic character set conversion between server and client for certain character set combinations. The conversion information is stored in the pg_conversion system catalog. PostgreSQL comes with some predefined conversions, as shown in Table 23.2. You can create a new conversion using the SQL command CREATE CONVERSION.

Table 23.2. Client/Server Character Set Conversions

To enable automatic character set conversion, you have to tell PostgreSQL the character set (encoding) you would like to use in the client. There are several ways to accomplish this:

• Using the encoding command in psql. encoding allows you to change client encoding on the fly. For example, to change the encoding to SJIS, type:

• libpq (Section 34.10) has functions to control the client encoding.

• Using SET client_encoding TO. Setting the client encoding can be done with this SQL command:

  Also you can use the standard SQL syntax SET NAMES for this purpose:

  To query the current client encoding:

  To return to the default encoding:

• Using PGCLIENTENCODING. If the environment variable PGCLIENTENCODING is defined in the client's environment, that client encoding is automatically selected when a connection to the server is made. (This can subsequently be overridden using any of the other methods mentioned above.)

• Using the configuration variable client_encoding. If the client_encoding variable is set, that client encoding is automatically selected when a connection to the server is made. (This can subsequently be overridden using any of the other methods mentioned above.)

If the conversion of a particular character is not possible — suppose you chose EUC_JP for the server and LATIN1 for the client, and some Japanese characters are returned that do not have a representation in LATIN1 — an error is reported.

If the client character set is defined as SQL_ASCII, encoding conversion is disabled, regardless of the server's character set. Just as for the server, use of SQL_ASCII is unwise unless you are working with all-ASCII data.

These are good sources to start learning about various kinds of encoding systems.

Contains detailed explanations of EUC_JP, EUC_CN, EUC_KR, EUC_TW.

The web site of the Unicode Consortium.

UTF-8 (8-bit UCS/Unicode Transformation Format) is defined here.