Clever Geek Handbook

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

So, I created some tables:

enter image description here

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

enter image description here

+3


source to share


1 answer


"To permanently change the search path in your cluster, change the search_path parameter in the parameter group that is currently associated with your cluster. See the link below for step-by-step instructions: -

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



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

0


source






More articles:


All Articles