Postico Modern & friendly PostgreSQL client Data Entry Table Schema Authoring SQL Query Editor. Postico is a modern, friendly database client. PostgreSQL c 11 12 date 1 2011-02 2 2011-02 3 2011-02- a 2011-02 s 2011-02- e 2011-02- 7 2011-02 g 2011-02- 2011-02- g 20-02- 15 -15 1. Postico 1.5 – A modern PostgreSQL client. December 21, 2018. Description of Postico 1.5.14 Postico provides an easy to use interface, making Postgres more accessible for newcomers and specialists alike. Postico will look familiar to anyone who has used a Mac before. Just connect to a database and begin working with tables and views.
Release date: 2019-08-08
This release contains a variety of fixes from 11.4. For information about new features in major release 11, see Section E.10.
A dump/restore is not required for those running 11.X.
However, if you are upgrading from a version earlier than 11.1, see Section E.9.
Require schema qualification to cast to a temporary type when using functional cast syntax (Noah Misch)
We have long required invocations of temporary functions to explicitly specify the temporary schema, that is pg_temp.func_name(args). Require this as well for casting to temporary types using functional notation, for example pg_temp.type_name(arg). Otherwise it's possible to capture a function call using a temporary object, allowing privilege escalation in much the same ways that we blocked in CVE-2007-2138. (CVE-2019-10208)
Fix execution of hashed subplans that require cross-type comparison (Tom Lane, Andreas Seltenreich)
Hashed subplans used the outer query's original comparison operator to compare entries of the hash table. This is the wrong thing if that operator is cross-type, since all the hash table entries will be of the subquery's output type. For the set of hashable cross-type operators in core PostgreSQL, this mistake seems nearly harmless on 64-bit machines, but it can result in crashes or perhaps unauthorized disclosure of server memory on 32-bit machines. Extensions might provide hashable cross-type operators that create larger risks. (CVE-2019-10209)
Fix failure of ALTER TABLE . ALTER COLUMN TYPE when altering multiple columns' types in one command (Tom Lane)
This fixes a regression introduced in the most recent minor releases: indexes using the altered columns were not processed correctly, leading to strange failures during ALTER TABLE.
Prevent dropping a partitioned table's trigger if there are pending trigger events in child partitions (Álvaro Herrera)
This notably applies to foreign key constraints, since those are implemented by triggers.
Include user-specified trigger arguments when copying a trigger definition from a partitioned table to one of its partitions (Patrick McHardy)
Install dependencies to prevent dropping partition key columns (Tom Lane)
ALTER TABLE . DROP COLUMN will refuse to drop a column that is a partition key column. However, indirect drops (such as a cascade from dropping a key column's data type) had no such check, allowing the deletion of a key column. This resulted in a badly broken partitioned table that could neither be accessed nor dropped.
This fix adds pg_depend entries that enforce that the whole partitioned table, not just the key column, will be dropped if a cascaded drop forces removal of the key column. However, such entries will only be created when a partitioned table is created; so this fix does not remove the risk for pre-existing partitioned tables. The issue can only arise for partition key columns of non-built-in data types, so it seems not to be a hazard for most users.
Ensure that column numbers are correctly mapped between a partitioned table and its default partition (Amit Langote)
Some operations misbehaved if the mapping wasn't exactly one-to-one, for example if there were dropped columns in one table and not the other.
Ignore partitions that are foreign tables when creating indexes on partitioned tables (Álvaro Herrera)
Previously an error was thrown on encountering a foreign-table partition, but that's unhelpful and doesn't protect against any actual problem.
Prune a partitioned table's default partition (that is, avoid uselessly scanning it) in more cases (Yuzuko Hosoya)
Fix possible failure to prune partitions when there are multiple partition key columns of boolean type (David Rowley)
Don't optimize away GROUP BY columns when the table involved is an inheritance parent (David Rowley)
Normally, if a table's primary key column(s) are included in GROUP BY, it's safe to drop any other grouping columns, since the primary key columns are enough to make the groups unique. This rule does not work if the query is also reading inheritance child tables, though; the parent's uniqueness does not extend to the children.
Avoid incorrect use of parallel hash join for semi-join queries (Thomas Munro)
This error resulted in duplicate result rows from some EXISTS queries.
Avoid using unnecessary sort steps for some queries with GROUPING SETS (Andrew Gierth, Richard Guo)
Fix possible failure of planner's index endpoint probes (Tom Lane)
When using a recently-created index to determine the minimum or maximum value of a column, the planner could select a recently-dead tuple that does not actually contain the endpoint value. In the worst case the tuple might contain a null, resulting in a visible error “found unexpected null value in index”; more likely we would just end up using the wrong value, degrading the quality of planning estimates.
Fix failure to access trigger transition tables during EvalPlanQual rechecks (Alex Aktsipetrov)
Triggers that rely on transition tables sometimes failed in the presence of concurrent updates.
Fix mishandling of multi-column foreign keys when rebuilding a foreign key constraint (Tom Lane)
ALTER TABLE could make an incorrect decision about whether revalidation of a foreign key is necessary, if not all columns of the key are of the same type. It seems likely that the error would always have been in the conservative direction, that is revalidating unnecessarily.
Don't build extended statistics for inheritance trees (Tomas Vondra)
This avoids a “tuple already updated by self” error during ANALYZE.
Avoid spurious deadlock errors when upgrading a tuple lock (Oleksii Kliukin)
When two or more transactions are waiting for a transaction T1 to release a tuple-level lock, and T1 upgrades its lock to a higher level, a spurious deadlock among the waiting transactions could be reported when T1 finishes.
Fix failure to resolve deadlocks involving multiple parallel worker processes (Rui Hai Jiang)
It is not clear whether this bug is reachable with non-artificial queries, but if it did happen, the queries involved in an otherwise-resolvable deadlock would block until canceled.
Prevent incorrect canonicalization of date ranges with infinity endpoints (Laurenz Albe)
It's incorrect to try to convert an open range to a closed one or vice versa by incrementing or decrementing the endpoint value, if the endpoint is infinite; so leave the range alone in such cases.
Fix loss of fractional digits when converting very large money values to numeric (Tom Lane)
Fix printing of BTREE_META_CLEANUP WAL records (Michael Paquier)
Prevent assertion failures due to mishandling of version-2 btree metapages (Peter Geoghegan)
Fix spinlock assembly code for MIPS CPUs so that it works on MIPS r6 (YunQiang Su)
Ensure that a record or row value returned from a PL/pgSQL function is marked with the function's declared composite type (Tom Lane)
This avoids problems if the result is stored directly into a table.
Make libpq ignore carriage return (r) in connection service files (Tom Lane, Michael Paquier)
In some corner cases, service files containing Windows-style newlines could be mis-parsed, resulting in connection failures.
In psql, avoid offering incorrect tab completion options after SET variable = (Tom Lane)
Fix a small memory leak in psql's d command (Tom Lane)
Fix pg_dump to ensure that custom operator classes are dumped in the right order (Tom Lane)
If a user-defined opclass is the subtype opclass of a user-defined range type, related objects were dumped in the wrong order, producing an unrestorable dump. (The underlying failure to handle opclass dependencies might manifest in other cases too, but this is the only known case.)
Fix possible lockup in pgbench when using -R option (Fabien Coelho)
Improve reliability of contrib/amcheck's index verification (Peter Geoghegan)
Fix handling of Perl undef values in contrib/jsonb_plperl (Ivan Panchenko)
Fix contrib/passwordcheck to coexist with other users of check_password_hook (Michael Paquier)
Fix contrib/sepgsql tests to work under recent SELinux releases (Mike Palmiotto)
Improve stability of src/test/kerberos and src/test/ldap regression tests (Thomas Munro, Tom Lane)
Improve stability of src/test/recovery regression tests (Michael Paquier)
Reduce stderr output from pg_upgrade's test script (Tom Lane)
Fix pgbench regression tests to work on Windows (Fabien Coelho)
Fix TAP tests to work with msys Perl, in cases where the build directory is on a non-root msys mount point (Noah Misch)
Support building Postgres with Microsoft Visual Studio 2019 (Haribabu Kommi)
In Visual Studio builds, honor WindowsSDKVersion environment variable, if that's set (Peifeng Qiu)
This fixes build failures in some configurations.
Charles 3 10 1 download free. Support OpenSSL 1.1.0 and newer in Visual Studio builds (Juan José Santamaría Flecha, Michael Paquier)
Allow make options to be passed down to gmake when non-GNU make is invoked at the top level (Thomas Munro)
Avoid choosing localtime or posixrules as TimeZone during initdb (Tom Lane)
In some cases initdb would choose one of these artificial zone names over the “real” zone name. Prefer any other match to the C library's timezone behavior over these two.
Adjust pg_timezone_names view to show the Factory time zone if and only if it has a short abbreviation (Tom Lane)
Historically, IANA set up this artificial zone with an “abbreviation” like Local time zone must be set--see zic manual page. Modern versions of the tzdb database show -00 instead, but some platforms alter the data to show one or another of the historical phrases. Show this zone only if it uses the modern abbreviation.
Sync our copy of the timezone library with IANA tzcode release 2019b (Tom Lane)
This adds support for zic's new -b slim option to reduce the size of the installed zone files. We are not currently using that, but may enable it in future.
Update time zone data files to tzdata release 2019b for DST law changes in Brazil, plus historical corrections for Hong Kong, Italy, and Palestine.
This page is a partial list of interactive SQL clients (GUI or otherwise) - that doesn't include reporting engines, ETL data loaders, or visual design tools, just interactive clients that you can type SQL in to and get results from them. This includes web based or desktop apps.
Clients compatible with only OS X.
(empty list)
Some of these have a 'free' tier (typically somewhat crippled).
The Complete Cross-Platform Database IDE for ALL(Mac, Windows, Linux)
Features:
macOS 10.8 and above
Features:
A modern, native tool with an elegant UI that allows you to simultaneously manage multiple databases, including PostgreSQL. Available on macOS, Windows, and iOS.
With plugin system, you can be able to write your own new features to work with database per your needs (export charts, pretty json…).
A nice native client by the developers of Postgres.app. A free 'demo' version of an inexpensive proprietary app, but it has very reasonable limits ('only one tab') and no time limit.
Postico is a fully native Mac app for connecting to your PostgreSQL server. It supports encrypted connections via SSL and SSH to PostgreSQL 8.0 and later, including Amazon Redshift.
Postico has a powerful table content editor with in-cell editing and form-based row editing in a sidebar. You can quickly filter tables by keywords or even complex SQL expressions.
There's also a table structure editor for editing columns, types, default values, foreign keys, check constraints etc.
Finally, there's a convenient SQL Query Editor with support for query history and syntax highlighting. It also has convenience features like auto-indent and shortcuts for comment line etc.
OS X Yosemite+, free not crippled. Last update: 2018. Digital minds screensavers collection ubserial download free. Native OS X
SEQUEL for PostgreSQL is a professional DB administration and management tool, with extremely intuitive and feature-rich GUI that makes it the best assistant tool for developers and admins. SEQUEL is lightweight, fast and powerful that it can significantly simplify the DB management process. For those who cannot live without a CLI, SEQUEL offers a powerful Query Editor with syntax highlight, autocomplete and a Console log view that is always visible, so you can monitor the communication with your databases. It includes:
Clients compatible with only windows.
HeidiSQL is a lightweight Windows desktop application with support for PostgreSQL since 2015. Also supports MySQL, MariaDB, MS SQL Server and SQLite. HeidiSQL focuses on simple structure editing and grid based data editing, but also has some advanced features:
dbForge Studio for PostgreSQL is a brand new tool for PostgreSQL database development, management, and editing process enjoyable and easy by Devart. The PostgreSQL IDE allows users to create, develop, and execute queries, edit and adjust the code to the requirements in a convenient and UI. The tool provides the PostgreSQL data editor functionality for queries customization and property window for viewing all the required information of PostgreSQL database objects.
Key features:
1) Query Profiler
2) SQL Development
3) Data Export and Data Import
4) Data Reports and Analysis
5) Object Explorer
6) Data Editor
7) Master-Detail Browser
Toothfairy 2 6 download free. Database Tour Pro is a database tool with built-in report builder for Windows. It works with different types of relational databases including PostgreSQL.
Key features:
Windows
SQLGate is a simple but powerful IDE for multiple Database including PostgreSQL.
Use SQLGate to maximize your productivity!
Java
Datazenit is a cross-platform PostgreSQL and MySQL GUI with data grid, schema builder and interactive charts.It also has query builder, raw query editor with auto-complete, team collaboration features like connection, query and chart sharing among team members.
Web-based, but available packaged as a desktop app (linux, Mac, windows)
EMS SQL Manager for PostgreSQL Freeware (EMS SQL Manager Lite for PostgreSQL) is an excellent and easy-to-use freeware graphical tool for PostgreSQL database administration. It has the minimal required set of tools for those users who are new to PostgreSQL server and need only its basic functionality.EMS SQL Manager for PostgreSQL Freeware allows you to work with servers, databases and schemas, view, edit, search, group, sort and filter any data stored in a database, create and execute SQL queries with powerful SQL editor, handle multiple selected objects at a time and much more.
There is a proprietary version available with significantly more functionality.
Allows you to create, edit, copy, drop and dump database objects easy and fast. https://truerfile800.weebly.com/uplet-1-2.html. You can also design your database as ER diagram, build queries visually, execute SQL queries and scripts, debug PL/pgSQL functions, view and edit data including BLOBs, represent data as diagrams, export and import data to/from most popular file formats, analyze your data summarized into multidimensional views and hierarchies (OLAP cubes), manage PostgreSQL roles, users, groups and privileges, and use a lot of other admin tools designed for making your work with PostgreSQL database server comfortable and efficient.
Nucleon Database Master is a modern, powerful, intuitive, easy to use and all in one PostgreSQL MongoDB, Oracle, DB2, Informix, Ingres, SQL Server, SQL Azure, MySQL, FireBird, SQLite client application with a consistent interface that simplifies managing, querying, editing, visualizing, designing and reporting relational and schema-free (NoSQL) database systems. You can connect any database system via ODBC and OleDB connections.Using Database Master, you can execute SQL, LINQ, JSON queries or you can create, edit and delete all database objects such as tables, views, procedures, columns, indexes, collections, and triggers. You can execute SQL queries and scripts, view and edit table data including BLOBs (Image, Text or any file), represent tables and its relations as an ER(Entity Relationship) diagram.
SqlPro is an easy to use database GUI tool for six popular databases (Oracle, MySQL, PostgreSQL, SQL Server, SQLite, and Access). One IDE makes database administration and development faster and error free.SQLPro Key Features: color-coding of the SQL, drag-and-drop of objects into the editor pane to save you from typing their names, retrieval of SQL code for things like stored procedures and triggers from the underlying database, and one-click creation of SELECT and INSERT statements. You can open, save and print SQL scripts.SQLPro uses native drivers to connect to the databases (no ODBC or third party engines to install).
Windows
SQL Data Analysis is a business intelligence tool that helps you see and understand your PostgreSQL data.
SQL Data Analysis helps you transform data into actionable insights. Free trial available at https://www.yohz.com/sda_details.htm
These clients are both 'free' and 'open source'
Beekeeper Studio is a modern cross-platform SQL editor and database manager available for Linux, Mac, and Windows. Some of its features include:
pgAdmin 4 is a ground-up rewrite of pgAdmin 3. Rather than being a native application it's primarily a web application that's also packaged as desktop web shell. But runs locally.
Open source, desktop application to manage your local or remote PostgreSQL databases.
windows/linux/OS X
A simple and lightweight SQL client desktop/terminalwith cross database and platform support. GUI or term.
Seen as a nice program, though possibly unmaintained now: https://github.com/sqlectron/sqlectron-gui/issues/433
Platforms that support Java
SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc. The minimum version of Java supported is 1.8.x as of SQuirreL version 3.8.1.
Commentor 1: If it doesn't start in OS X (like nothing appears) see https://sourceforge.net/p/squirrel-sql/bugs/1398/
Windows, Linux, FreeBSD, macOS, OpenBSD, Solaris
For many years the 'standard' freely available GUI client for Postgresql, and so is bundled in many packaged installers. It provides a SQL query tool, an editor for procedural languages and a CRUD interface. It's also one of the few clients to provide a GUI front end to the plpgsql debugger.
Free Administration Centre for the PostgreSQL database. Includes a graphical administration interface, an SQL query tool, a procedural code editor and much more. pgAdmin III is designed to answer the needs of most users, from writing simple SQL queries to developing complex databases. The graphical interface supports all PostgreSQL features and makes administration easy. Available in more than 30 languages and for several operating systems.
pgAdmin III is an Open Source management tool for PostgreSQL databases. Features full Unicode support, fast, multithreaded query and data editing tools and support for all PostgreSQL object types.
pgAdmin III is bundled with the Windows installer on older versions of Postgres, and you can use that as a client to administer a remote server on another OS. Note that binary packages for platforms like RPM don't show up in every point release, you currently have to go back to v1.8.0 to get the last full set of packages.
Development has been discontinued by pgadmin.org, but is still being maintained by BigSQL who are doing basic maintenance to support newer versions of PostgreSQL and packaging it for current OS releases [here].
Linux, Windows, macOS
Oracle, MySQL, and PostgreSQL, as well as limited support for ODBC targets. Inspired by the proprietary Toad client.
Java
An OpenSource (though it prohibits usage by government agencies from USA, UK, Canada, China, Russia, North Korea, Syria, Saudi Arabia, Turkey and the Chechen Republic) SQL GUI tool similar to Squirrel. Data can be edited directly in the result set. It has strong support for exporting and importing data between databases using its own SQL command extension. It can be used in GUI mode or as a console application. All SQL Workbench specific commands can also be run in batch mode to automate export and import task. It supports schema comparison ('diff') and copying data between databases.
It has some restrictions on use by government employees.
Java
Supports many SQL databases from different vendors, as well as few NoSQL ones (Cassandra, etc).Good query editor with syntax highlighting, completion and autosave.Editing of query results. SSH tunneling support. Tons of other cool features.Quite good, but not 100% perfect PostgreSQL support (yet?).
Has a free community and also 'pro' version available.
An alternative to pgAdmin, which runs in both application and server modes.
These are 'closed source' apps, some offer free demo's.
Windows, Linux
Basically a proprietary, more powerful version of PGAdmin II or PGAccess. Adds support for trigger and constraint editing, metadata logging, and query monitoring. Also includes multiple-format data import/export tools, which are also available on their own for Linux. Developed by EMS Hitech. (JMB 4.2003).
Windows/OS X/Linux/
Valentina Studio is a powerful PostgreSQL Database Server administration and development tool. It offers for free many advanced editors:
Valentina Studio PRO - adds additional advanced features as: We the revolution 1 3 0.
Macintosh/Windows/Linux/Solaris
RazorSQL is an SQL query tool, database browser, SQL editor, and database administration tool that supports PostgreSQL and any other JDBC or ODBC compliant database. Some of the major features are tools for creating, dropping, and altering objects such as tables, views, indexes, triggers, functions, users, and databases; a programming editor that supports 20 different programming languages; import and export tools; auto column and table lookup; and a query builder, query scheduler, and SQL formatter.
Windows, Mac OS X, Linux
JetBrains has a dedicated SQL IDE — DataGrip which can connect to PostgreSQL as well. It provides code completion, multi cursors, local query history, navigation, refactorings and language injection support.https://www.jetbrains.com/datagrip/
Other JetBrains Products, for example, PHPStorm, IDEA, have built-in database plugin, and it has the same functionality as DataGrip.
After you configured the data sources of your project, you can easily create tables, foreign keys, indexes much easier than usual, because the IDE is very smart; for example by foreign keys it automatically sets the name of the key and the related columns. For me, it is so far the best experience by creating a basic database schema. Even with editable EER models was it slower.By the settings of your data source you can configure the SQL dialect of your database. After that, if you want to add stored procedures or triggers, you will have code completion which is favorable too. So I think JetBrains products speed up your work if you exactly know what you want, and how can you make it.
For any JetBrains IDE, there is a free license for open source projects. For enterprise usage there is a 30 days trial, after that, you can buy a personal or proprietary license which is very cheap compared to other products.
Java: Windows/Linux/macOS/Solaris
Aqua Data Studio is a management tool for the PostgreSQL relational database w/ administration capabilities and a database query tool. The visual administration features provide users the ability to browse and modify database structures, including schema objects, database storage and maintain database security. An integrated query tool allows users to quickly create, edit and execute SQL queries and scripts. Aqua Data Studio also provides an import and export tool to allow users to easily move data in and out of the PostgreSQL database in and from different data formats.
Windows, macOS, iOS, Linux
Navicat is a powerful PostgreSQL Database Server administration and development tool. It works with PostgreSQL 8.0 version or above and supports most of the PostgreSQL features including Trigger, Function, View, Manage User, and so on. Apeaksoft screen recorder for mac 1 0 8. It is also not only sophisticated enough for professional developers, but also easy to learn for new users. With its well-designed GUI, Navicat lets you quickly and easily create, organize, access and share information in a secure and easy way.
Version 15 introduces Smart Charts, a more powerful Data Transfer, Query Builder, New Data Modeling Tool, Dark Mode, and Native Linux support.
Windows, Mac OS X, Linux
Datazenit is a cross-platform PostgreSQL and MySQL GUI with data grid, schema builder and interactive charts.It also has query builder, raw query editor with auto-complete, team collaboration features like connection, query and chart sharing among team members.
Available packaged as a desktop app.
Windows & Mac OS X
PostgreSQL, MySQL and MariaDB support.
Supports SQLite 3.x, MySQL 8.0, MariaDB 10, PostgreSQL 11.Query, Editing, Designer, Export+Import = Full support. Hint, modeling and DB sync are on the roadmap.Windows, Linux, MacOS X
Web clients run as a server on your desktop and you connect to them via a web browser. This also allows things like coworkers to connect as well. You can run SQL against servers and back the results (in your browser).
These are open source and free:
phpPgAdmin is a web-based administration tool for PostgreSQL. It is perfect for PostgreSQL DBAs, newbies, and hosting services.
Web client, either hosted (free) or running locally, connects to a local postgresql instance via a small bridge application.
Can share the interface with others, rather like sqlfiddle.com, but accessing your database.
pgAdmin 4 is a ground-up rewrite of pgAdmin 3. Rather than being a native application it's primarily a web application that's also packaged as desktop web shell.
PHP
Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. A single PHP file ready to deploy to the target server. Adminer is available for MySQL, PostgreSQL, SQLite, MS SQL and Oracle.
Django/Python on Linux, Windows and macOS.
Open source full-featured tool for database management. Currently supports PostgreSQL (9.3 - 11), Oracle (11g - 18c), MySQL (5.6 - 8.0) and MariaDB (10.1 - 10.3). More RDBMS support coming soon, including the ability of converting databases from any supported RDBMS to PostgreSQL and back.
PHP
Schema and data browser and editor.
Node.js
Hisha is cross-platform and web-based Postgre SQL Database client inspired by Adminium. You can edit and save result by clicking the cell you want and press enter when you finish.
Tadpole DB Hub is Unified infrastructure tool, a various environment based interface for managing Apache Hive, Amazon RDS, CUBRID, MariaDB, MySQL, Oracle, SQLite, MSSQL, PostgreSQL and MongoDB databases. It enables you to handle typical DB over the World Wide Web.
Features:
Some may be pay, some may have free demo.
browser-based, webserver included
AJAX/JavaScript-powered web interface for PostgreSQL administration. Browse, maintain and create data and database objects from anywhere, in the web browser. Supports SSH for both the web interface and the database connections. Rich interface with tabbed SQL editor with auto-completion, inline row-editing widgets, click-through foreign key navigation between rows and tables, 'favorites' management for commonly used scripts, and more.
Installers available for Windows, Mac and Linux, alternatively download a simple cross-platform archive that runs anywhere with simple script.Wasn't clear where source code is.
Html5 Web Browser (Linux/Mac OS X/Windows)
JackDB is a database client that runs entirely in your web browser. There's no software to install locally so you can use it on Mac OS X, Linux, and Windows and it works on all major modern browsers (eg. Chrome, Firefox, IE, Safari, and Opera). It supports connecting to PostgreSQL, as well as MySQL, Oracle, and SQL Server databases.
Features:
Web Browser (Linux/Mac OS X/Windows)
DBHawk is a web based SQL tool and reporting software designed for PostgreSQL, Oracle, SQL Server and other databases. Its easy to deploy and use.
Razer synapse 3 mac. Features:
Datazenit is a cross-platform PostgreSQL and MySQL GUI with data grid, schema builder and interactive charts.It also has query builder, raw query editor with auto-complete, team collaboration features like connection, query and chart sharing among team members.
Web-based, but available packaged as a desktop app (linux, Mac, windows)
The standard command line client, maintained by the postgresql development group and typically distributed as part of the server installation.
A command line client with syntax highlighting and pop-up command completion.
A universal JDBC command line client with lots of features. It is not specific to PostgreSQL, but it is pre-configured to handle PostgreSQL servers. Requires PostgreSQL JDBC driver.
Community Guide to PostgreSQL GUI Tools - Includes many miscellaneous non-client tools, such as bulk loaders, schema diff, schema design, etc.
Design Tools - tools for designing database schemas
Old possibly abandoned projects, see Community_Guide_to_PostgreSQL_Tools_Abandoned
0 
Star