"Andreas 'ads' Scherbaum" <adsmail@xxxxxxxxxxxxx> writes: >> SELECT datname FROM pg_database; > Is this guaranteed to stay forever? It seems reasonably unlikely that we'd change it. Even if we did, we have in the past provided compatibility views (cf pg_user, pg_shadow) when removing a catalog --- I would think the same would happen for pg_database if we ever removed it. > Isn't there a way to make the list of databases available in > information_schema and change this view whenever the underlaying > structure might change? The point of information_schema is that it's standardized. There is no view in the SQL standard that corresponds to a list of databases. If you think there ought to be, take it up with the SQL committee. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin