Re: [GENERAL] Listing tables in all schemas in psql

2010-04-21 Thread Thom Brown
On 21 April 2010 22:26, Tom Lane wrote: > Thom Brown 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

Re: [GENERAL] Listing tables in all schemas in psql

2010-04-21 Thread Tom Lane
Thom Brown writes: > This may sound like a stupid question, but how do you list all tables in all > schemas in psql? \dt *.* regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgres

[GENERAL] Listing tables in all schemas in psql

2010-04-21 Thread 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