SyntaxFix
Write A Post
Hire A Developer
Questions
\df <schema>.*
in psql gives the necessary information.
psql
To see the query that's used internally connect to a database with psql and supply an extra "-E" (or "--echo-hidden") option and then execute the above command.
-E
--echo-hidden