Re: Dropping a database that does not exist - Mailing list pgsql-general

Tham Shiming <shiming@misatravel.com> 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