Category:	Developer Tools
Price:	Free
Popularity:	Low
Version String:	8.12
Release Date:	2024-09-20
Architecture:	Intel & AppleSilicon(ARM)
Minimum OS:	macOS 11.0.0
Vendor Name:	pgAdmin Development Team
Homepage:	www.pgadmin.org

Description:

PostgreSQL Tools

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.

pgAdmin may be used on macOS to manage PostgreSQL and EDB Advanced Server 9.5 and above.

Features

pgAdmin has a huge array of features and by far the best way to see them all is to download a copy and give it a try. Here's a brief list to give you an idea of its capabilities:

Designed for multiple PostgreSQL versions and derivatives

• PostgreSQL 9.5 and above
• EDB Postgres Advanced Server 9.5 and above

Extensive documentation

• pgAdmin application documentation
• PostgreSQL documentation links

Multiple deployment models

• Desktop mode, using a purpose built runtime
• Server mode, supporting multiple users over the web

Tools

• Powerful query tool with colour syntax highlighting
• Fast datagrid for display/entry of data
• Graphical query plan display
• Grant Wizard for rapid updates to ACLs
• Procedural language debugger (supporting pl/pgsql and edb-spl)
• Schema diff tool for managing differences between schemas

Routine maintenance

• Auto-vacuum management
• Monitoring dashboard
• Backup, restore, vacuum and analyze on demand
• SQL/shell/batch job scheduling agent

Create, view and edit all common PostgreSQL objects

Objects are displayed with their SQL definition, and a user friendly list of properties. Dependent, and dependency objects may also be browsed, and object statistics viewed where appropriate.

• Aggregates
• Casts
• Columns
• Constraints
• Databases
• Domains
• Foreign tables
• Foreign servers
• Foreign data wrappers
• FTS configurations
• FTS dictionaries
• FTS parsers
• FTS templates
• Functions
• Indexes
• Languages
• Materialized views
• Roles
• Rules
• Procedural languages
• Schemas
• Sequences
• Tables
• Tablespaces
• Trigger functions
• Types
• Views
• EDB Postgres Advanced Server objects (such as packages, procedures and synonyms)
• pgAgent objects (such as jobs, schedules)

Multibyte support

pgAdmin supports most PostgreSQL server-side encodings:

• SQL_ASCII
• EUC_JP, EUC_CN, EUC_KR, EUC_TW
• JOHAB
• LATIN1, LATIN2, LATIN3, LATIN4, LATIN5, LATIN6, LATIN7, LATIN8, LATIN9, LATIN10
• ISO_8859_5, ISO_8859_6, ISO_8859_7, ISO_8859_8
• UNICODE/UTF-8
• MULE_INTERNAL
• KOI8
• WIN
• ALT
• WIN1256
• TCVN
• WIN874