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 |