基于Web的PostgreSQL數據庫管理工具：PostgreSQL Studio
PostgreSQL Studio是一個基于Web的PostgreSQL數據庫管理工具。可以利用它來編輯你的數據代碼，瀏覽你的數據庫結構和運行完整的SQL查詢。
特性
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.
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.
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.
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…
