Why are my tables not listed in the Redshift pg_table_def system table?

Question

So I have created some tables:

But they are not listed when I query pg_table_def? Any ideas appreciated.

Answer 1

"For modifying the search path permanently on your cluster , please modify the search_path parameter in the parameter group that is currently associated with your cluster. For step by step instructions please refer to the link below :-

http://docs.aws.amazon.com/redshift/latest/mgmt/managing-parameter-groups-console.html "

https://forums.aws.amazon.com/thread.jspa?threadID=131150