Finding out about the dates of table modification

From: Martin Mueller <martinmueller(at)northwestern(dot)edu>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Finding out about the dates of table modification
Date: 2019-11-23 02:24:30
Message-ID: 479EA81C-AB5D-4032-AD86-94F71AA83E6A@northwestern.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've moved happily from MySQL to Postgres but miss one really good feature of MYSQL: the table of tables that let you use SQL queries to find out metadata about your table. Thus looking at the table of tables and sorting it by last change, lets you quickly look at the most recently modified table. Which is really useful if you have a bad memory, as I do, and can't remember the name of a particular table that I worked on last Wednesday.

Are those capabilities hidden somewhere in Postgres? There isn't an obvious section in the documentation. At least I can't find it.

Martin Mueller
Professor emeritus of English and Classics
Northwestern University

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lelarge 2019-11-23 06:29:24 Re: Finding out about the dates of table modification
Previous Message Adrian Klaver 2019-11-23 00:06:14 Re: And I thought I had this solved.