PostgreSQL 查看数据库修改时间

查看数据库创建、修改信息

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;