Tham Shiming <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend