list of external schema and tables from postgresql

I have created external schema and external table in redshift. I able to see external schema name in postgresql using \dn 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?

I tried select * from information_schema.tables where table_schema not in ('pg_catalog', 'information_schema') and table_schema not like 'pg_toast%' but didn't got the list of external table...

Read More »

By: StackOverFlow - Sunday, 17 June

Related Posts