Redshift Database Query Tool Features
RazorSQL is a database client that supports the Amazon Redshift database. AWS Redshift uses the PostgreSQL database as its database implementation, and RazorSQL includes many features for working with PostgreSQL databases. It provides a custom Redshift database browser tailored to Redshift, a Redshift SQL editor with Redshift specific features and syntax highlighting, custom Redshift GUI tools, and Redshift specific database administration tools. Listed below are more details on these features.
- Redshift Import Tool and Redshift Export Tool for importing data into tables, or exporting data from single tables or all tables in a database
- A GUI Redshift create table tool
- Redshift Database Backup Tools for backing up entire PostgreSQL / Redshift schemas or single tables.
- Tools for creating Redshift views and indexes
- A Redshift create function tool for generating the SQL to create PostgreSQL / Redshift functions
- A Redshift create trigger tool for generating the SQL to create PostgreSQL / Redshift triggers
- A Redshift alter table tool for generating the SQL to alter Redshift tables
- SQL Drop Tools for dropping tables, views, indexes, functions and, triggers, for Redshift
- A visual edit table tool for visually editing Redshift tables in a spreadsheet format
- Tools for editing functions, and triggers for Redshift.
- A Generate DDL Tool for Redshift for generating Redshift table, view, and index DDL.
- Displays information in a tree format for schemas, tables, views, functions, triggers, indexes, constraints, users, and roles
- Displays Redshift 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
Edit SQL scripts. Run SQL queries. Auto column and auto table lookup. Supports over 20 programming languages including SQL, PHP, HTML, XML, Java, and more.
Redshift Database Conversion Tools
Convert database tables from PostgreSQL / Redshift to other database types and from other database types to PostgreSQL.
Below is a screen shot of the RazorSQL AWS Redshift GUI Tool
