Skip to content

Instantly share code, notes, and snippets.

@pixelead0

pixelead0/view_databases.sql

Created June 17, 2021 13:06
Show Gist options
  • Save pixelead0/70130fbfaac7e28a75af0c61d4c63a06 to your computer and use it in GitHub Desktop.
Save pixelead0/70130fbfaac7e28a75af0c61d4c63a06 to your computer and use it in GitHub Desktop.
Download ZIP
postgres - Listar todas las bases de datos existentes y sus fechas de creación
Raw
view_databases.sql
SELECT (pg_stat_file('base/'||oid ||'/PG_VERSION')).modification, datname FROM pg_database order by 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment