List of schemas in my database;
postgres=# \dn
List of schemas
| Name | Owner |
| ------------------------- | ------------- |
| information_schema | postgres84 |
| pg_catalog | postgres84 |
| pg_toast | postgres84 |
| pg_toast_temp_1 | postgres84 |
| public | postgres84 |
| statsinfo | postgres84 |
| statsrepo | postgres84 |
I need to get the list of tables from the schema "statsrepo".
postgres=# set search_path to statsrepo;
postgres=# \d
List of relations
| Schema | Name | Type | Owner |
| --------- | ----------------------- | ----------- | ------------ |
| statsrepo | activity | table | postgres84 |
| statsrepo | autoanalyze | table | postgres84 |
| ... |
|
|
|
| statsrepo | tablespace | table | postgres84 |
