Re: Listing tables in all schemas in psql

From: Thom Brown <thombrown(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PGSQL Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Listing tables in all schemas in psql
Date: 2010-04-21 21:30:16
Message-ID: y2mbddc86151004211430v2b9bb02yc6cef85d7c7a09b2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 21 April 2010 22:26, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Thom Brown <thombrown(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John Gage 2010-04-21 22:07:10 Identical command-line command will not work with \i metacommand and filename
Previous Message Tom Lane 2010-04-21 21:26:59 Re: Listing tables in all schemas in psql