PostgreSQL Database Query Tool Features

The PostgreSQL database query tool features provided by RazorSQL include a custom database browser tailored to PostgreSQL, a PostgreSQL SQL editor with PostgreSQL specific features and syntax highlighting, custom PostgreSQL visual tools, and PostgreSQL specific database administration tools. Listed below are more details on these features.

PostgreSQL Visual Tools

  • A PostgreSQL create table tool that generates PostgreSQL specific create table SQL that includes such elements as column names, column types, column lengths or precisions, column scales, nullability, unique constraints, default values, and the ability to add check constraints.
  • A PostgreSQL create view tool that generates the SQL for creating PostgreSQL views
  • A PostgreSQL create index tool that generates the SQL for creating PostgreSQL indexes and includes elements such as index name, uniqueness, and columns
  • A PostgreSQL create function tool for generating the SQL to create PostgreSQL functions
  • A PostgreSQL create trigger tool for generating the SQL to create PostgreSQL triggers
  • A PostgreSQL create database tool that generates the PostgreSQL create database SQL.
  • A PostgreSQL create user tool that generates PostgreSQL create user SQL.
  • A PostgreSQL alter table tool for generating the SQL to alter PostgreSQL tables with such options as add column, add primary key, add foreign key, add constraint, rename table, rename column, drop column, drop primary key, drop foreign key, and drop constraint
  • A PostgreSQL alter view tool for generating the SQL to alter PostgreSQL views
  • SQL Drop Tools for dropping tables, views, indexes, functions, triggers, databases, and users for PostgreSQL
  • A visual edit table tool for visually editing PostgreSQL tables in a spreadsheet format
  • Tools for editing functions, and triggers for PostgreSQL.
  • PostgreSQL Import and Export tools for importing data into tables, or exporting data from single tables or all tables in a database
  • A PostgreSQL SQL Explain Plan tool

PostgreSQL Database Browser

  • Displays information in a tree format for schemas, tables, views, functions, triggers, indexes, constraints, users, and roles
  • Displays PostgreSQL table information such as column name, column type, column length, column nullability, and primary and foreign key information
  • Easily view table contents or database object information via the View Contents and Show Info context menu options