Features

Connects to multiple versions of PostgreSQL

PostgreSQL Studio can connect to the most recent versions of PostgreSQL as well as some of the most popular open source folks of PostgreSQL. You can connect PostgreSQL Studio to:

  • PostgreSQL 9.5.x
  • PostgreSQL 9.4.x
  • PostgreSQL 9.3.x
  • PostgreSQL 9.2.x
  • Postgres-XL 9.2
  • Postgres-XC 1.0.x
  • Postgres-XC 1.1.x
  • Postgres-XC 1.2.x
  • vFabric Postgres
  • Heroku Postgres
  • Amazon RDS for PostgreSQL

Easy to install and configure

PostgreSQL Studio is written is Java using the Google Web Toolkit. Just drop the war file into your favorite Servlet container and you’re ready to go. Deploy PostgreSQL Studio on:

  • Windows
  • Linux
  • Mac
  • Unix

Using:

  • Tomcat
  • Jetty
  • JBoss
  • GlassFish
  • and more…

Secure Database Access

PostgreSQL Studio runs in your browser over a standard HTTP/S connection. This let’s you put PostgreSQL Studio behind your firewall and you can access your database without opening up port 5432 to the world. You can keep your database locked away even in your Cloud environment.

Schema Browser

The Schema Browser provides an easy way to navigate database objects. The database objects are displayed for the currently active connection for your selected schema.

schema_browser

Detail Browser

The Detail Browser shows each database object’s features and allows for their modification. The functions available such as creating an index and granting security depend on the particular database object.

detail_browser

SQL Worksheet

The SQL Worksheet handles processing of individual SQL statements during a database session. Any executed statements can also show the SQL execution plan which provides a detailed outline for how PostgreSQL processes each statement.

sql_worksheet

Object Wizards

The Object Wizards allows you to create database objects without needing to know the PostgreSQL syntax. Just click through the wizards and create your objects. PostgreSQL Studio lets you create:

  • Tables
  • Views
  • Indexes
  • Constraints
  • Triggers
  • Sequences
  • Row Level Security Policies
  • and more…

trigger_wizard

index_wizard