Hi Ray, I'm not sure how your DB has an OID of 4 digits. pgAdmin considers all DBs with OIDs less than equal to 16383 as system DBs. So your DB here is considered a system DB.
On Fri, Nov 29, 2024 at 6:32 PM Ray O'Donnell <r...@rodonnell.ie> wrote: > Hi all, > > I've just come across a funny in pgAdmin 4 version 8.13: when I connect > from my laptop to a server on the same laptop, not all databases are > listed in the tree-view on the left. The server is PostgreSQL 16.6. > > Connecting to the server with psql and doing \l shows me 12 databases, > including template0 and template1. Likewise, "select * from pg_database" > gives me the same 12 rows. However, the treeview shows only 9... > template* databases are excluded, plus one other of my own. > > Interestingly, when I select from pg_database, the one database of mine > which is excluded has an OID of 4; all the others have 5-digit OIDs. I > don't know why its OID is so low; it's come forward through a few PG > versions over several years, so probably historical baggage. > > All the best, > > Ray. > > -- > Raymond O'Donnell // Galway // Ireland > r...@rodonnell.ie > > > > -- Thanks, Aditya Toshniwal pgAdmin Hacker | Sr. Staff SDE II | *enterprisedb.com* <https://www.enterprisedb.com/> "Don't Complain about Heat, Plant a TREE"
