FlyData Blog

Redshift Show Tables | How to List Redshift Tables
 • 
In order to list or show all of the tables in a Redshift database, you'll need to query the PGTABLEDEF systems table. An interesting thing to note is the PG_ prefix. This is because Redshift is based off Postgres, so that little prefix is a throwback to Redshift’s Postgres origins. Running SELE...
Redshift vs. Postgres: A Detailed Comparison
 • 
Amazon Redshift was birthed out of PostgreSQL 8.0.2. For this reason, many analysts and engineers making the move from Postgres to Redshift feel a certain comfort and familiarity about the transition. While it is true that much of the syntax and functionality crosses over, there are key differenc...
Redshift Copy: How and when to use Redshift's COPY command
 • 
In this guide, we’ll go over the Redshift COPY command, how it can be used to import data into your Redshift database, its syntax, and a few troubles you may run into. What is the Redshift COPY command? The Redshift COPY command, funnily enough, copies data from one source and loads it into you...
Redshift Join: How to use Redshift's Join Clause
 • 
Redshift’s JOIN clause is perhaps the second most important clause after SELECT clause, and it is used even more ubiquitously, considering how interconnected a typical application database’s tables are. Due to that connectivity between datasets, data developers require many joins to collect and p...
Redshift Vacuum: Optimize your Redshift tables
 • 
Because Redshift does not automatically “reclaim” the space taken up by a deleted or updated row, occasionally you’ll need to resort your tables and clear out any unused space. Doing so can optimize performance and reduce the number of nodes you need to host your data (thereby reducing costs). Th...
Get started. Try FlyData.
Quick setup. No credit card required. Unlimited sync during trial.
Fast and secure Enterprise-grade security and near real-time sync.
World-class support Proactive monitoring from technical experts, 24/7.
Straightforward pricing Pay for the rows you use, and nothing you don’t.