Listing tables in all schemas in psql
Started by Thom Brownalmost 16 years ago3 messagesgeneral
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
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
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