Listing tables in all schemas in psql

From: Thom Brown <thombrown(at)gmail(dot)com>
To: PGSQL Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Listing tables in all schemas in psql
Date: 2010-04-21 21:24:57
Message-ID: q2lbddc86151004211424kbde346dbpf3c561777cba4788@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

This may sound like a stupid question, but how do you list all tables in all
schemas in psql? \d and \d+ don't do it, and putting the schema name after
it isn't allowed. Just listing tables within a single schema would be fine.

Thanks

Thom

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-04-21 21:26:59 Re: Listing tables in all schemas in psql
Previous Message Tom Lane 2010-04-21 21:08:16 Re: Returning a char from a C-language function