1

Is it possible to find out the date a table was loaded into a PostGIS schema using PgAdmin3?

The tables are usually supplied from varying external sources.

1

1 Answer 1

1

2 ways:

  1. By creating trigger functions for your data tables, which insert "update timestamps" into an update_log table. See this
  2. If you want to find out the historical update time for a table, the manual method is to find the file node name from the pg_class for your table

    select relfilenode from pg_class where relname = 'tablename'
    

    Locate the relfilenode file in your system. The last updated system time of that file node is your last update time of your table. (from PostgreSQL forums)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.