Tham Shiming <shiming@xxxxxxxxxxxxxx> writes: > OK, checking pg_shadow, the usesysid for each entry is unique. > pg_database, however, showed the duplicate databases. A short sample > output from pgAdmin. > datname datdba > db1 101 > db1 101 > db2 102 > db3 103 > db3 103 Does anyone know what the underlying query is that pgadmin uses for this display? regards, tom lane
