How to find table creation time?

by

I had a look through the pg_* tables, and I couldn’t find any creation times in there. It’s possible to locate the table files, but then on Linux you can’t get file creation time. So I think the answer is that you can only find this information on Windows, using the following steps:

  • get the database id with select datname, datdba from pg_database;
  • get the table filenode id with select relname, relfilenode from pg_class;
  • find the table file and look up its creation time; I think the location should be something like <PostgreSQL folder>/main/base/<database id>/<table filenode id> (not sure what it is on Windows).

More Related Contents:

  1. PostgreSQL LIKE query performance variations
  2. How to import CSV file data into a PostgreSQL table
  3. Calculating and saving space in PostgreSQL
  4. Equivalent to unpivot() in PostgreSQL
  5. PostgreSQL: ERROR: 42601: a column definition list is required for functions returning “record”
  6. I forgot the password I entered during postgres installation
  7. how to emulate “insert ignore” and “on duplicate key update” (sql merge) with postgresql?
  8. How do I efficiently select the previous non-null value?
  9. How do I do large non-blocking updates in PostgreSQL?
  10. Does not using NULL in PostgreSQL still use a NULL bitmap in the header?
  11. How to generate the “create table” sql statement for an existing table in postgreSQL
  12. PostgreSQL: serial vs identity
  13. Postgres password authentication fails
  14. Generate series of dates – using date type as input
  15. Copy a few of the columns of a csv file into a table
  16. Returning from a function with OUT parameter
  17. ERROR: permission denied for relation tablename on Postgres while trying a SELECT as a readonly user
  18. Joining Results from Two Separate Databases
  19. PL/pgSQL functions: How to return a normal table with multiple columns using an execute statement
  20. Postgresql query array of objects in JSONB field
  21. Multicolumn index on 3 fields with heterogenous data types
  22. Select from a table variable
  23. Heroku database restore issue
  24. user postgres launches process that takes all CPUs 100% usage
  25. PostgreSQL disable more output
  26. PostgreSQL array_agg order
  27. Postgres table column name restrictions?
  28. How do I get min, median and max from my query in postgresql?
  29. PostgreSQL jsonb, `?` and JDBC
  30. Syntax error at end of input in PostgreSQL

Leave a Comment