I have a situation where I want to fetch data from a table if it exists, otherwise take data from another table. A pseudo code is below: SELECT * FROM table1 IF table1 exists else SELECT * FROM table2; I tried many things but could not achieve what I wanted. I am using redshift.