pgAdmin is an open source comprehensive design and management interface designed specifically for the PostgreSQL database. It was developed by the PostgreSQL Global Development Group and first released in January 2002. It features compatibility to most operating systems including Linux, Windows, Mac OSX, and FreeBSD. pgAdmin runs as a native application no matter which environment. This is because pgAdmin is executed in binary code and not in a virtual machine.
pgAdmin user interface features a simple gray window display. It supports connection to PostgreSQL 7.3 and 7.4, as well as, 8.x database utilizing a libpq native library embedded in the program. pgAdmin does not need a .NET, ODBC, or JDBC layer. Under New Server registration, users can fill up the name, host, port, SSL, Password, DB restrictions, Service, and group. When a selected object is highlighted, its properties and statistics are shown on the right pane of the interface. The SQL definition display also utilizes colour syntax highlighting. Double-clicking a selected object in the navigation tree opens a separate dialog box. Users may also choose to create a new object upon double clicking an object. pgAdmin also features a tabbed interface showing tabs for Properties, Options, Parameters, Definition, Variables, Privileges, and SQL. pgAdmin also features a table editor that allows users to modify column data information through drop down choices. Modifications depend on the server version utilized by the user.