title: List of external schemas and tables from Amazon Redshift
body: <p>I have created external schema and external table in Redshift. I'm able to see external schema name in postgresql using \dn. </p>
  
  <p>What will be query to do it so that i can run it in java? and also the query to get list of external table? </p>
  
  <p>I tried </p>
  
  <pre><code>select * from information_schema.tables where 
  table_schema not in ('pg_catalog', 'information_schema') 
  and table_schema not like 'pg_toast%' 
  </code></pre>
  
  <p>but it didn't get the list of external tables.</p>