Thursday, October 21, 2010

List all tables from a specific schema in Postgresql


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

Leave a Reply