查看数据库创建、修改信息
SELECT (pg_stat_file('base/'||oid ||'/PG_VERSION')).modification, datname FROM pg_database;
SELECT (pg_stat_file(‘base/’||oid ||’/PG_VERSION’)).modification, datname FROM pg_database;
或者
SELECT (pg_stat_file('base/'||oid ||'/PG_VERSION')).modification a, datname FROM pg_database ORDER BY a desc;