The application has been successfully tested with both 32-bit and 64-bit hardware platforms. It is a software developed by a community of database experts around the world, it’s translated into more than 30 languages and supports all mainstream operating systems, including all GNU/Linux distribution, several BSD flavors, and the commercial Mac OS X and Microsoft Windows OSes. The application has been deigned in such a way that it gives you instant access to all PostgreSQL objects, including aggregates, domains, constraints, casts, functions, operator classes and families, columns, rules, PostgreSQL servers, tablespaces, views, roles, Slony-I objects like clusters and nodes, as well as pgAgent objects like schedules and jobs.Īdditionally, it give you access to conversions, databases, FTS configurations, parsers, templates and dictionaries, Greenplum objects like resource queues and external tables, groups, indexes, users, languages, types, tables, operators, schemas, trigger functions, sequences, server-side languages like Python, Perl and pgSQL, and Postgres Plus Advanced Server objects, such as synonyms, packages and procedures. Gives you instant access to all PostgreSQL objects PgAdmin III supports most of the PostgreSQL server-side encodings, including SQL_ASCII, EUC, JOHAB, LATIN, ISO_8859_5, ISO_8859_6, ISO_8859_7, ISO_8859_8, UNICODE UTF-8, MULE_INTERNAL, KOI8, WIN, ALT, WIN1256, TCVN and WIN874. Navicat (DB Admin Tool for MySQL, PostgreSQL, MongoDB, MariaDB, SQL Server, Oracle & SQLite client) is another favourite but they are not free. I have used it for Postgres and Redshift. Supported PostgreSQL server-side encodings Answer (1 of 3): SQL Workbench (SQL Workbench/J - Home) is a fabulous free tool. With a GUI (Graphical User Interface) that supports all PostgreSQL features, pgAdmin III’s key features include native PostgreSQL access, auto-vacuum management, logfile browser, lock viewer, server status and process viewer, comprehensive Slony-I and PostgreSQL documentation, as well as shell, SQL and batch job scheduling agent.

It supports the PostgreSQL 7.3 and later database server, as well as the Postgres Plus Advanced Server and Greenplum database engines. PgAdmin is an open source, cross-platform, freely distributed and very powerful software project specifically designed for viewing, browsing, querying and developing complex PostgreSQL databases.

Download pgadmin 4