-
Title
Feature comparison of Redshift with other DB Platforms -
Description
Toad Edge currently offers a limited level of support for the Redshift database platform. The constructed matrix that contrasts the features that Redshift supports or doesn’t support, is shown below.
-
Resolution
Features
Supported by PostgreSQL/EDB[Yes/No]
Supported by Redshift DB[Yes/No/Limited]
Notes
SQL Worksheet/Editor
-
Content Assist
-
Syntax Check
-
Hint Window
-
Quick doc
-
Code Formatting
-
Multiple statement execution
-
Execute all/to/from
-
Result grid
Explain Query
Yes
Yes
RedShift implementation for TE inherits its syntax from PostgreSQL
Data Editor/Detailed Explorer
-
Object Viewer(table,views, etc.)
-
Editable result grid
-
Script viewer
-
Add
Yes
No
-
Detailed Viewer isn’t present for Redshift.
-
Result Grid, is present but it’s not editable
Export and Import
-
Export data
-
Import data
Yes
Yes
Export/Import data from object explorer and result grid only.
Schema compare
Yes
No
Snapshot
Yes
No
CI/CD
Yes
No
Outline View
Yes
No
Advanced User Privilege Management
Yes
No
Object Explorer
-
Refresh
-
Set schema as default
-
Drop/ Cascade drop
-
Truncate
-
Copy table/Record Count
Yes
Yes
The Objects which are supported by Toad Edge are:
Table, Views, Materialized Views, Functions, Procedures, Constraints, Roles, Users, Groups.
New Object Wizards
-
New Table wizard
-
New View wizard
-
New function wizard
-
New schema wizard
etc….
Yes
No
The Wizard to create any object isn’t present.
Object Search
Yes
Limited
Limited support(Searched objects can’t be opened since Detailed Explorer isn’t present in Redshift)
Text Search
Yes
No
Sessions/Lock view
Yes
Yes/No
Repository(VCS)
Yes
No
Backup and Restore
Yes
No
Direct Script Execution
Yes
Yes
JSON in place data editor
Yes
No
Disable/Enable Autocommit
Yes
Yes
SQL Recall
Yes
Yes
SQL Monitor
Yes
Yes
DBMS_OUTPUT
Yes (For EDB)
No
SQL Warnings
Yes
Yes
Run Routines
Yes
Yes
Switch Database
Yes
Yes
Error View
Yes
Yes
-