Обсуждение: Listing tables in all schemas in psql

Поиск
Список
Период
Сортировка

Listing tables in all schemas in psql

От
Thom Brown
Дата:
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

Re: Listing tables in all schemas in psql

От
Tom Lane
Дата:
Thom Brown <thombrown@gmail.com> writes:
> This may sound like a stupid question, but how do you list all tables in all
> schemas in psql?

\dt *.*

            regards, tom lane

Re: Listing tables in all schemas in psql

От
Thom Brown
Дата:
On 21 April 2010 22:26, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Thom Brown <thombrown@gmail.com> writes:
> This may sound like a stupid question, but how do you list all tables in all
> schemas in psql?

\dt *.*

                       regards, tom lane

Ah, yes, thanks Tom.  That's exactly what I was trying to find.

Thom