postgresql 列出某个数据库下的某个schema下面所有的表

查了好多资料没找到想要的答案，结果fan qiang找到了，记录一下，仅供分享。

select * from pg_tables where schemaname = 'schema_name'

完整request

{
  "query": "select * from pg_tables where schemaname = 'xxx';",
  "database": "test",
  "user": "xxx",
  "password": "xxx",
  "type": "CSV"
}