[leo8]

This a thousand times. I have to ALWAYS google that one big query for showing me all the databases. (I almost always connect with pgAdmin)

[deathanatos]

I'm confused; in what context are you always googling it? In pgAdmin, its displayed in the UI, no?

(I sort of agree with the parent, in that, if you need this in a raw SQL interface, it's a pain. But it shouldn't be a common pain point?)

[leo8]

Ok, that makes no sense, now I see. I was talking about SHOW TABLES actually.

In pgAdmin I would have to expand every schema to see every table.

Was a bit tired when writing that comment.

[deathanatos]

Ah, another UI that hides information by default. Those are annoying.

(I'm a CLI user, so it's a \dt away. But I Googled screenshots of pgAdmin prior to commenting to see if it was in the UI, and it/was.)