| From: | Ray O'Donnell <ray(at)rodonnell(dot)ie> |
|---|---|
| To: | Pgadmin-Support <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Some databases not listed in treeview |
| Date: | 2024-11-29 13:01:52 |
| Message-ID: | 01020193780372c4-b488dd2b-b1aa-4900-bad8-770dfccd6642-000000@eu-west-1.amazonses.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
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
ray(at)rodonnell(dot)ie
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aditya Toshniwal | 2024-12-02 03:10:01 | Re: Some databases not listed in treeview |
| Previous Message | Sarafas, Thanos | 2024-11-28 15:20:47 | password to SQL Shell (psql) |